<<

Contents

Search

>>

 

JDBC_TABLE_NAMES$

 

 

Function

 

 

Syntax:

JDBC_TABLE_NAMES$(<File Number>,<Type>)

 

<File Number>

= <NUM-EXPRESSION>

<Type>

= <STRING-EXPRESSION>

 

 

Meaning:

Returns the table names and table types in the following format:

 

"<NAME-1>|<TYPE-1>|<NAME-2>|<TYPE-2>|..."

 

<Type> specifies which table type is to be returned. If <Type> is the empty string "", all table names are returned, otherwise only those of the specified <Type>.

 

JDBC_TABLE_NAMES$ returns the empty string "" if an error occurred.

 

If an error occurs, the variable OK contains the error number and the function JDBC_GET_LAST_ERROR$ returns the error text.

 

Parameter:

File Number

Number of JDBC database

 

Type

The following table types are possible:

 

TABLE

VIEW

SYSTEM TABLE

GLOBAL TEMPORARY

LOCAL TEMPORARY

ALIAS

SYNONYM

 

 

Sample:

NAMES$ = JDBC_TABLE_NAMES$(2)

IF OK <> 0

THEN ERRORMES = JDBC_GET_LAST_ERROR$ QUIT

ENDIF

 

NAMES$ contains e.g.:

"CUSTOMER|TABLE|ARTICLE|TABLE"

 

See also:

JDBC_COL_NAMES$

JDBC_INDEX_NAMES$