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

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

   The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

Hot Links

» Home Page
» My Forum
» Email Me
» My Shop

Site Menu

»Affiliate Market«
     »Featured Product


»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

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

»Fun Stuff«

Old Projects
»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads
»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«
Links

» Downloads

 

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
Information

Your IP Address is: 54.145.183.34

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


(A)bort, (R)etry or (G)et a stick and kill it.

 

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

     
  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius