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

 

FORMSQUE

DBase Directory Location: GMBASE
Table Description: Queue of mail-merged documents waiting to be sent.

Table Indexes
Name DBase Index SQL Index ID
FQDATE RECTYPE+DTOS(ONDATE)+FORMNO+ROUTING RECTYPE+ONDATE+FORMNO+ROUTING -
FQFORMNO FORMNO+RECTYPE+DTOS(ONDATE) FORMNO+RECTYPE+ONDATE -
FQUSERID USERID+RECTYPE+DTOS(ONDATE)+ROUTING USERID+RECTYPE+ONDATE+ROUTING -
FQRECID RECID RECID -

Table Relationships
Field Related Table to Field Type Notes
FormNo Forms->RecID M-1 Links the queued form to the original form.

Table Fields Structure
Field Name Field Type Length Description
RECTYPE String 1 Record Type. Q=Queue record (standard).
ROUTING String 1 Routing flag (where it’s going to)
     0=Printer
     1=Fax
FORMNO String 15 Identifies form queued. Links to RecID of Forms table.
ACCOUNTNO String 20 AccountNo of the Contact record that is queued. If the record is an additional contact, this is the RecID of the associated ContSupp record.
USERID String 8 Username that queued this record.
ONDATE Date 8 Date the queued form is scheduled to be run (printed, faxed, etc)
TRACKNO String 15 If created by automated process, the RecID of the AP.
DIRCODE String 10 If created by an AP, the File Code associated with the database (File | Open Database - Properties - File Code).
CREATEBY String 8 Username that created this record.
STATUS String 1 If 1, record queued is an additional contact, if blank, a primary.
PRINTERID String 60 Printer ID
PRTYID String 15 Priority ID
LASTUSER String 8 Last Modified By
LASTDATE Date 8 Last Modified Date
LASTTIME String 5 Last Modified Time
RECID String 15 Record ID


Welcome
Information

Your IP Address is: 18.226.222.12

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


FILES=1 BUFFERS=0 FCBS=SAYWHAT BREAK=GIMME

 

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