|  |
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.
|
|
|
What is a sniglet? It is a word that inadvertently got left out of the dictionary (after all, Mr. Webster has only so many hands).For example,the special mixture of popcorn butter and Coke syrup that covers the floors of movie theatres as called CINEMUCK.
If you have some sniglets to contribute, send them to me by electronic mail.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
