js editor
Web development
Returns a value corresponding to the table type.
SYS(2029 [, nWorkArea | cTableAlias]) |
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.
Return Value
Character
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.
| В |  Copy Code |
|---|---|
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 | |