Databases

DATABASE (data\database.dbc)

Free Tables

VFXAUDIT (data\vfxaudit.dbf)
VFXFOPEN (data\vfxfopen.dbf)
VFXHELP (vfxhelp.dbf)
VFXLOCK (data\vfxlock.dbf)
VFXLOG (data\vfxlog.dbf)
VFXMSG (data\vfxmsg.dbf)
VFXPATH (vfxpath.dbf)
VFXREP (data\vfxrep.dbf)
VFXRES (data\vfxres.dbf)
VFXRTEMP (data\vfxrtemp.dbf)
VFXRTYPE (data\vfxrtype.dbf)
VFXSYS (data\vfxsys.dbf)
VFXSYSID (data\vfxsysid.dbf)
VFXUSR (data\vfxusr.dbf)

Table: VFXAUDIT

 Fields
Name Type Length
TABLE C 8
RECORDID C 30
USER C 32
DATETIME T 8
CHANGES M 4

Indexes
Name Expression
AUDIT UPPER(TABLE)

Table: VFXFOPEN

 Fields
Name Type Length
OBJECTID C 10
OBJECTNO N 3
TITLE C 32
DESCR C 120
FORM C 32
PARAMETER M 4
VIEWLEVEL N 2
NEWLEVEL N 2
EDITLEVEL N 2
ERASELEVEL N 2

Indexes
Name Expression
OBJECT UPPER(OBJECTID)+STR(OBJECTNO)

Table: VFXHELP

 Fields
Name Type Length
HELPID N 9
OBJECTPATH C 240
HELPTEXT M 4
INDEX C 50
BOOK C 50
BOOK2 C 50
CHAPTER C 50
TITLE C 50
PICTURE M 4

Indexes
Name Expression
HELPID HELPID
OBJECTPATH UPPER(OBJECTPATH)
BOOKS UPPER(BOOK+CHAPTER)

Table: VFXLOCK

 Fields
Name Type Length
TABLE C 32
RECORD N 10
DATE D 8
TIME C 10
USER_NAME C 32

Indexes
Name Expression
KEY UPPER(TABLE)+STR(RECORD,10)

Table: VFXLOG

 Fields
Name Type Length
TYPE C 10
USER C 32
DATE D 8
TIME C 10
ERROR N 4
MESSAGE M 4
METHOD M 4
TABLES M 4
CODE M 4
MEMORY M 4
STATUS M 4

Indexes
Name Expression
OBJECT UPPER(USER)

Table: VFXMSG

 Fields
Name Type Length
VFX C 1
MESSAGE_ID C 64
OBJNAME C 64
TYPE C 10
SORT C 80
TEXT M 4
ENG M 4
ESP M 4
FRE M 4
ITA M 4
GER M 4
USR M 4
TIMESTAMP T 8

Indexes
Name Expression
KEY UPPER(MESSAGE_ID)
TYPE UPPER(TYPE+VFX)
SORT SORT

Table: VFXPATH

 Fields
Name Type Length
CLIENTNAME C 20
DATAPATH C 64
UPDATEPATH C 64
REPORTPATH C 64
VFXPATH C 64
EXPORTPATH C 64
IMPORTPATH C 64

Indexes
Name Expression
DELETED DELETED()
CLIENTNAME UPPER(CLIENTNAME)

Table: VFXREP

 Fields
Name Type Length
REPORTID I 4
RTYPEID I 4
FILENAME C 10
DESCR M 4
USER C 32

Indexes
Name Expression
ID REPORTID
REPORTID RTYPE
RTYPE RTYPEID
RTYPEID FILENAME
FILENAME STR(RTYPEID,10)+UPPER(FILENAME)

Table: VFXRES

 Fields
Name Type Length
USER C 32
OBJNAME C 128
INDEX M 4
DESCENDING L 1
LAYOUT M 4
PAGE N 3
TOOLBAR L 1

Indexes
Name Expression
USER UPPER(USER)+UPPER(OBJNAME)

Table: VFXRTEMP

 Fields
Name Type Length
RTEMPLID I 4
FILENAME C 10
DESCR M 4
RTYPEID I 4
USER C 32

Indexes
Name Expression
ID RTEMPLID
RTYPE RTYPEID
FILENAME STR(RTYPEID,10)+UPPER(FILENAME)

Table: VFXRTYPE

 Fields
Name Type Length
RTYPEID I 4
FILENAME C 6
DESCR C 40
SORT I 4

Indexes
Name Expression
ID RTYPEID
SORT SORT

Table: VFXSYS

 Fields
Name Type Length
MAGIC_ID C 15

Table: VFXSYSID

 Fields
Name Type Length
KEYNAME C 32
VALUE C 10
MAXLEN N 4

Indexes
Name Expression
KEY UPPER(KEYNAME)

Table: VFXUSR

 Fields
Name Type Length
USER C 32
PASSWORD C 32
USER_NAME C 32
USERLEVEL N 2
USERACCESS C 10
FIRSTVIEW N 1
LASTSEL M 4
FORMSIZE N 3,1
AGENT L 1
FAVORITES M 4
LASTFILE N 2

Indexes
Name Expression
NAME UPPER(USER_NAME)
USER UPPER(USER)