
|  |
INFOMINE
GMBASE
InfoCenter file—stores all data for the InfoCenter
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 |
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 |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
 |
INTERESTING FACTS ABOUT THE COMMON COLD:
Studies involving volunteers exposed to the elements show that cold, wetness,and drafts don't increase the chances of catching a cold.And Arctic explorers never get colds...unless they receive visitors. Colds occur more often in wintertime, when people crowd together indoors and have more chances to infect one another...It's probably easier to catch a cold by shaking hands than by kissing...Studies of kissing couples -- one with a cold, one without -- found that osculation seldom led to inoculation.
-- Consumer Reports, Jan 1989
|
|
|
|
|