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

 

CONTTLOG

Table Description: Log file of field/record changes to all COMMON tables. Used for synchronization.

Table Indexes
Name SQL Index  
CTLOGDAT TABLEID+SYNCSTAMP  
CTLUSER USERID+TABLEID+FRECID  
CTLSTAMP SYNCSTAMP+TABLEID+FIELDNAME+FRECID  
CTLOGTRN TABLEID+FRECID+FIELDNAME  
CTLFREC FRECID  
CTLOGFRECF FRECID+FIELDNAME  

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
SYNCSTAMP String 7 Date and time that the record was added to the contact set
LOGSTAMP String 7 Date and time that GoldMine recorded the activity
ACTION String 2 Code indicating action to take (New, Delete, Update)
TABLEID String 1 Code indicating table name
Value Description
& Contact1
Contact2
( ContSupp
) ContHist
* ContGrps
0 ContUDef
FRECID String 15 Record ID for the record affected
FIELDNAME String 10 Changed field name or action taken on record (New, Delete)
USERID String 9 License # or Username preceeded by tilde (~)


Welcome
Information

Your IP Address is: 44.222.233.8

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


Lottery: A tax on people who don't understand statistics.

 

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