次の方法で共有


SYS(2029) - Table Type

Returns a value corresponding to the table type.

SYS(2029 [, nWorkArea | cTableAlias])

Return Value

Character

Parameters

  • nWorkArea
    Specifies the work area in which the table is open.

  • cTableAlias
    Specifies the alias of the table. If you omit nWorkArea and cTableAlias, SYS(2029) returns a value for the table open in the currently selected work area.

Remarks

The following table lists the values returned by SYS(2029) and the corresponding table type:

Return value

Table type

0

No table open.

3

Previous versions of FoxPro, FoxBASE+, dBASE III PLUS, and dBASE IV with no memo field.

48

Visual FoxPro with or without a memo field.

49

Visual FoxPro with an Autoinc field (Visual FoxPro 8 and greater).

50

Visual FoxPro with a Varchar, Varbinary or Blob field (Visual FoxPro 9 and greater).

67

dBASE IV SQL table with no memo field.

99

dBASE IV SQL System table with a memo field.

131

FoxBASE+ and dBASE III PLUS table with a memo field.

139

dBASE IV table with a memo field.

203

dBASE IV SQL table with a memo field.

245

Previous versions of FoxPro with a memo field.

Example

The following example opens the customer table in the testdata database.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE Customer     && Open customer table

CLEAR
DO CASE
   CASE SYS(2029) = '3'
      ? 'Previous versions of FoxPro'
   CASE SYS(2029) = '48'
      ? 'Visual FoxPro Table'
   CASE SYS(2029) = '67'
      ? 'dBASE IV SQL table, no memo fields'
   CASE SYS(2029) = '99'
      ? 'dBASE IV SQL System table with a memo field'
   CASE SYS(2029) = '131'
      ? 'FoxBASE+ table with a memo field'
   CASE SYS(2029) = '139'
      ? 'dBASE IV table with a memo field'
   CASE SYS(2029) = '203'
      ? 'dBASE IV SQL table with a memo field'
   CASE SYS(2029) = '245'
      ? 'Previous versions of FoxPro with a memo field'
ENDCASE

See Also

Reference

ALTER TABLE - SQL Command

CREATE Command

CREATE TABLE - SQL Command

USE Command

SYS( ) Functions Overview