Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Returns a value corresponding to the table type.
SYS(2029 [, nWorkArea | cTableAlias])
Return Values
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 |
| 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