JDBC_INDEX_NAMES$
|
Syntax: |
JDBC_INDEX_NAMES$(<File
Number>,<Table Name>)
|
||||||||
|
|
|
||||||||
|
Meaning: |
Returns the keys of a table in the following
format: <INDEXTYPE-1> | <INDEXNAME-1> |
<COLUMN NAME-1> | <SORTING-1> | <INDEXTYPE-2> | <INDEXNAME-2> |
< COLUMN NAME -2> | < SORTING -2> | ..."
JDBC_INDEX_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: |
|
||||||||
|
Sample: |
INDEX$ = JDBC_INDEX_NAMES$(2,"ADDRESS") IF OK <> 0 THEN ERRORMES
= JDBC_GET_LAST_ERROR$ QUIT ENDIF The content of
INDEX$ is, for example: "0|Address0|Name1|A|0|Address0|Name2|A|1|Address1|Phone|D" In this example the
table "ADDRESS" has two Index keys, that are "Address0"
and "Address1". The Index key "Address0" is unique and
the Index key "Address1" is not unique. The Index key
"Address0" consists of the two file fields "Name1" and
"Name2", which are sorted in ascending order respectively. The Index key
"Address1" only consists of the field "Phone", which is
sorted in descending order. |
||||||||
|
See also: |
|