Google
 
Return Home  
GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API wrapper and GoldFORM the GoldMine webimport form builder

   The home of Enigma NETUpdate automatic web update, GoldFORM and GMGoldLINK a GoldMine API wrapper

Hot Links

» Home Page
» Forum Pages
» Email Me

Site Menu
»GoldMine«
     »GoldFORM
     »GMCrystalView
     »GoldMine API
     »GoldMine Tables
     »GoldMine INI
     »Downloads
     »Free Tools

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads
Old Projects
»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links
»IRCDominatorXT«

»Work In Progress«
Links

» Downloads

Home

GMTLOG

DBase Directory Location: GMBASE
Table Description: Log file of field/record changes to all GMBASE tables. Used for synchronization.

NOTE: Some table changes do not generate GMTLog entries.

Table Indexes
Name DBase Index SQL Index ID
GTLOGDAT TABLEID+SYNCSTAMP TABLEID+SYNCSTAMP -
GTLOGTRN TABLEID+FRECID+FIELDNAME TABLEID+FRECID+FIELDNAME -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
SYNCSTAMP String 7 Encrypted date and time that the activity occurred during processing.
LOGSTAMP String 7 Encrypted date and time that GoldSync or GoldMine recorded the activity.
ACTION String 2 Code indicating action taken ((N)ew, (D)elete, (U)pdate)
TABLEID String 1 Code indicating table in which action occurred.
Value Description
“ (quote) Cal
R Cases (GoldMine 8.5.x)
6 Fields5
+ Filters
# Forms
2 ImpExp
3 InfoMine
! (exclamation) Lookup
; (semi-colon) MailBox
W Notes (GoldMine 8.5.x)
B OpMgr
/ PerPhone
5 Report32
1 ResItems
4 Scriptsw
 - (hyphen) SpFiles
= Syslog
7 Tracks
9 UserLog
. (period) Users
FRECID String 15 RecID in table. This identifies the specific record affected.
FIELDNAME String 10 Fieldname that was changed or code indicating type of New or Deleted record. Codes used are listed below.
     zsNew
     zzNew
     zzzDel
     zzzDelCOMP
USERID String 9 Username (preceeded by a tilde ‘~’) or license # that created this record.


Welcome

Enter a long URL and get it shortened using MyURL.online

Information

Your IP Address is: 54.242.94.204

Experts Exchange
#1
#2
#3
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT
Messages


Life without danger is a waste of oxygen.

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
Site Meter  
News

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc