Returns a value corresponding to the table type.
Syntax
SYS(2029 [, nWorkArea | cTableAlias])
Returns
Character
Arguments
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 |
| 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 |