TABLE

Syntax

Example

Description/Remarks

TABLE "table_type"

TABLE "VDATA"

This command returns the table name specified in the current configuration for the table_type you specify.

Valid table_type parameters are:

ACTIONCA

MFILTER

AUDITTRL

PLAN_VAL

CAUSE

PLAN_AUX

DASHDT

REPORT

DASHRET

SCHFILE

DASHSW

SESSION

DDATA

SFILTER

DDAT_AUX

STATLIST

DDT

TEMPLATE

DESKTOP

TRACEMST

DFILTER

TRPRIMST

DMDL

UDL1

DNOTE

UDL2

DPRI

UDL3

DPRI_DT

UDL4

DPROC

UDL5

DPROCDL

UDL6

DSTATS

VDATA

DSTDS

VDAT_AUX

EVENT

VMON

EVENTCA

VMON_AUX

FILTER

VNOTE

HSICFG

VPRI

HSIRPT *

VPRI_DT

HSIUC

VSTDS

* Note:  If you perform SQL queries on the HSIRPT table, do not try to access the HSIFILE column in this table. Limitations of the database access method used by SPC Data Entry will make the program crash if it tries to access this column.

The table_type must be from the list or the command will return "TABLE_NAME_ERROR".

For systems using Btrieve or Pervasive databases, the command will return the entire file path and name of the data file. For other databases, the command will return the table name.

See Tables Used in GainSeeker 8 for a description of each table.