Google
 
Return Home  
GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API wrapper and GoldFORM the GoldMine webimport form builder

   The home of Enigma NETUpdate automatic web update, GoldFORM and GMGoldLINK a GoldMine API wrapper

Hot Links

» Home Page
» Forum Pages
» Email Me

Site Menu
»GoldMine«
     »GoldFORM
     »GMCrystalView
     »GoldMine API
     »GoldMine Tables
     »GoldMine INI
     »Downloads
     »Free Tools

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads
Old Projects
»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links
»IRCDominatorXT«

»Work In Progress«
Links

» Downloads

Home

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

Enter a long URL and get it shortened using MyURL.online

Information

Your IP Address is: 54.242.94.204

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


I personally think we developed language because of our deep need to complain.

-- Lily Tomlin

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
Site Meter  
News

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc