Clarion Community Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
| **Navigation:**  ISAM File Drivers > Basic Database Driver >====== Basic:Supported Commands and Attributes ====== | [[basic driver strings.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[btrieve database driver.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

|  | **File Attributes** | **Supported** |
|  | CREATE | Y |
|  | DRIVER(//filetype// [,//driver string//]) | Y |
|  | NAME | Y |
|  | ENCRYPT | N |
|  | OWNER(//password//) | N |
|  | RECLAIM | N |
|  | PRE(//prefix//) | Y |
|  | BINDABLE | Y |
|  | THREAD | Y4 |
|  | EXTERNAL(//member//) | Y |
|  | DLL([//flag//]) | Y |
|  | OEM | Y |
|  | **File Structures** | **Supported** |
|  | INDEX | N |
|  | KEY | N |
|  | MEMO | N |
|  | BLOB | N |
|  | RECORD | Y |
|  | **Index, Key, Memo, Attributes** | **Supported** |
|  | BINARY | N |
|  | DUP | N |
|  | NOCASE | N |
|  | OPT | N |
|  | PRIMARY | N |
|  | NAME | N |
|  | Ascending Components | N |
|  | Descending Components | N |
|  | Mixed Components | N |
|  | **Field Attributes** | **Supported** |
|  | DIM | Y |
|  | OVER | Y |
|  | NAME | Y |
|  | **File Procedures** | **Supported** |
|  | BOF(//file//) | N |
|  | BUFFER(//file//) | N |
|  | BUILD(//file//) | N |
|  | BUILD(//key//) | N |
|  | BUILD(//index//) | N |
|  | BUILD(//index//,// components//) | N |
|  | BUILD(//index//,// components//,// filter//) | N |
|  | BYTES(//file//) | Y5 |
|  | CLOSE(//file//) | Y |
|  | COPY(//file//,// new file//) | Y |
|  | CREATE(//file//) | Y |
|  | DUPLICATE(//file//) | N |
|  | DUPLICATE(//key//) | N |
|  | EMPTY(//file//) | Y |
|  | EOF(//file//) | Y |
|  | FLUSH(//file//) | N |
|  | LOCK(//file//) | Y |
|  | NAME(//label//) | Y |
|  | OPEN(//file//,// access mode//) | Y |
|  | PACK(//file//) | N |
|  | POINTER(//file//) | Y2 |
|  | POINTER(//key//) | N |
|  | POSITION(//file)// | Y3 |
|  | POSITION(//key)// | N |
|  | RECORDS(//file//) | N |
|  | RECORDS(//key//) | N |
|  | REMOVE(//file//) | Y |
|  | RENAME(//file//,// new file//) | Y |
|  | SEND(//file//,// message//) | Y |
|  | SHARE(//file//,// access mode//) | Y |
|  | STATUS(//file//) | Y |
|  | STREAM(//file//) | N |
|  | UNLOCK(//file//) | Y |
|  | **Record Access** | **Supported** |
|  | ADD(//file//) | Y |
|  | ADD(//file//,// length//) | N |
|  | APPEND(//file//) | Y |
|  | APPEND(//file//,// length//) | N |
|  | DELETE(//file//) | N |
|  | GET(//file//,//key)// | N |
|  | GET(//file//,// filepointer//) | Y |
|  | GET(//file//,// filepointer//,// length//) | N |
|  | GET(//key//,// keypointer//) | N |
|  | HOLD(//file//) | N |
|  | NEXT(//file//) | Y |
|  | NOMEMO(//file//) | N |
|  | PREVIOUS(//file//) | N |
|  | PUT(//file//) | Y1 |
|  | PUT(//file//,// filepointer//) | Y1 |
|  | PUT(//file//,// filepointer//, //length//) | N |
|  | RELEASE(//file//) | N |
|  | REGET(//file,string//) | Y |
|  | REGET(//key,string//) | N |
|  | RESET(//file,string//) | Y |
|  | RESET(//key,string//) | N |
|  | SET(//file//) | Y |
|  | SET(//file//,// key//) | N |
|  | SET(//file//,// filepointer//) | Y |
|  | SET(//key//) | N |
|  | SET(//key//,// key//) | N |
|  | SET(//key//,// keypointer//) | N |
|  | SET(//key//,// key//,// filepointer//) | N |
|  | SKIP(//file//,// count//) | N |
|  | WATCH(//file//) | N |
|  | **Transaction Processing** | **Supported** |
|  | LOGOUT(//timeout//,// file, ..., file//) | N |
|  | COMMIT | N |
|  | ROLLBACK | N |
|  | **Null Data Processing** | **Supported** |
|  | NULL(//field//) | N |
|  | SETNULL(//field//) | N |
|  | SETNULL(//file//, //field//) | N |
|  | SETNONNULL(//field//) | N |

**Notes**

1.When using PUT() with this driver you should take care to PUT back the same number of characters that were read. If you PUT back more characters than were read, then the "extra" characters will overwrite the first part of the subsequent record. If you PUT back fewer characters than were read, then only the first part of the retrieved record is overwritten, while the last part of the retrieved record remains as it was prior to the PUT().

2.POINTER() returns the relative byte position within the file.

3.POSITION(file) returns a STRING(4).

4.THREADed files consume additional file handles for each thread that accesses the file.

5.BYTES() returns the actual bytes read from the file. The size of the clipped RECORD may be different depending on the file driver and it's DRIVER() strings. With the ASCII or BASIC file drivers BYTES will include the ENDOFRECORD (typically 13,10) byte count, but these bytes are not in the RECORD. With the ASCII driver the /TAB driver string can affect (expand, change or remove) the tab (9) characters in the record buffer resulting in a different length.