GoldMine Table Definitions

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

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

»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«

DBase Directory Location: GMBASE
Table Description: InfoCenter file—stores all data for the InfoCenter

Table Indexes
Name	DBase Index	SQL Index	ID
INFOMINE	UPPER(RECTYPE+LEFT(TSECTION,80)+LEFT(TOPIC,10)	RECTYPE+U_TSECTION+U_TOPIC	57
INFOSORT	SORTKEY	SORTKEY	58
INFOTRAN	RECTYPE+RECID	RECTYPE+RECID	59
INFRECID	RECID	RECID	60

Table Fields Structure
Field Name	Field Type	Length	Description
ACCOUNTNO	String	20	Account Number of contact if linked
CREATEBY	String	8	Creation User
RECTYPE	String	10	Record Type (‘IO1’=Global, ‘P0’Username=Private to specified user)
SORTKEY	String	20	Unique Sort Key. Formatted as date and time the record was created
TSECTION	String	100	Section
TOPIC	String	80	Topic
KEYWORDS	String	80	Keywords
OPTIONS	String	10	Options
OPTIONS1	String	20	Options1
OPTIONS2	String	20	Options2
LINKEDDOC	Memo	-	Several parameters, each separated by two tildes (~~) before and a line feed (ASCII 10) after. Parameters include: SYNC={0/1 – No/Yes}, CREATETIME=YYYYMMDDHHMMSS, FILENAME={Full path of directory and linked file name}.
NOTES	Memo	-	Notes (formatted as RTF)
USERREAD	String	8	User/Group with read access (Blank=Public)
USERWRITE	String	8	User/Group with write access (Blank=Public)
LASTUSER	String	8	Last Modified By
LASTDATE	Date	-	Last Modified Date
LASTTIME	String	5	Last Modified Time
U_TSECTION	String	100	Upper-case shadow of Section (SQL Only)
U_TOPIC	String	80	Upper-case shadow of Topic (SQL Only)
RECID	String	15	Record ID

Your IP Address is: 162.158.79.158

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

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

Darren Lawrence aka MrEnigma/AbsoluteGenius