Clarion:Supported Commands and Attributes

Top  Previous  Next

 

File Attributes

Supported

 

CREATE

Y

 

DRIVER(filetype [,driver string])

Y

 

NAME

Y

 

ENCRYPT

Y

 

OWNER(password)

Y1

 

RECLAIM

Y

 

PRE(prefix)

Y

 

BINDABLE

Y

 

THREAD

Y8

 

EXTERNAL(member)

Y

 

DLL([flag])

Y

 

OEM

Y

 

File Structures

Supported

 

INDEX

Y

 

KEY

Y

 

MEMO

Y

 

BLOB

N

 

RECORD

Y

 

Index, Key, Memo Attributes

Supported

 

BINARY

Y9

 

DUP

Y

 

NOCASE

Y

 

OPT

Y

 

PRIMARY

Y

 

NAME

Y

 

Ascending Components

Y

 

Descending Components

N

 

Mixed Components

N

 

Field Attributes

Supported

 

DIM

Y

 

OVER

Y

 

NAME

Y

 

File Procedures

Supported

 

BOF(file)

Y2

 

BUFFER(file)

N

 

BUILD(file)

Y

 

BUILD(key)

Y

 

BUILD(index)

Y

 

BUILD(index, components)

Y

 

BUILD(index, components, filter)

N

 

BYTES(file)

Y

 

CLOSE(file)

Y

 

COPY(file, new file)

Y

 

CREATE(file)

Y

 

DUPLICATE(file)

Y

 

DUPLICATE(key)

Y

 

EMPTY(file)

Y

 

EOF(file)

Y2

 

FLUSH(file)

Y

 

LOCK(file)

Y

 

NAME(label)

Y

 

OPEN(file, access mode)

Y

 

PACK(file)

Y

 

POINTER(file)

Y3

 

POINTER(key)

Y3

 

POSITION(file)

Y4

 

POSITION(key)

Y4

 

RECORDS(file)

Y

 

RECORDS(key)

Y

 

REMOVE(file)

Y

 

RENAME(file, new file)

Y

 

SEND(file, message)

Y

 

SHARE(file, access mode)

Y

 

STATUS(file)

Y

 

STREAM(file)

Y

 

UNLOCK(file)

Y

 

Record Access

Supported

 

ADD(file)

Y10

 

ADD(file, length)

N

 

APPEND(file)

Y

 

APPEND(file, length)

N

 

DELETE(file)

Y

 

GET(file,key)

Y

 

GET(file, filepointer)

Y

 

GET(file, filepointer, length)

N

 

GET(key, keypointer)

Y

 

HOLD(file)

Y

 

NEXT(file)

Y

 

NOMEMO(file)

Y

 

PREVIOUS(file)

Y

 

PUT(file)

Y10

 

PUT(file, filepointer)

Y

 

PUT(file, filepointer, length)

N

 

RELEASE(file)

Y

 

REGET(file,string)

Y

 

REGET(key,string)

Y

 

RESET(file,string)

Y

 

RESET(key,string)

Y

 

SET(file)

Y

 

SET(file, key)

Y

 

SET(file, filepointer)

Y

 

SET(key)

Y

 

SET(key, key)

Y

 

SET(key, keypointer)

Y

 

SET(key, key, filepointer)

Y

 

SKIP(file, count)

Y

 

WATCH(file)

Y

 

Transaction Processing

Supported5

 

LOGOUT(timeout, file, ..., file)

Y6,7

 

COMMIT

Y

 

ROLLBACK

Y

 

Null Data Processing

Supported

 

NULL(field)

N

 

SETNULL(field)

N

 

SETNULL(file,field)

N

 

SETNONNULL(field)

N

Notes

1      We recommend using a variable password that is lengthy and contains special characters because this more effectively hides the password value from anyone looking for it. For example, a password like "dd....#$...*&" is much more difficult to "find" than a password like "SALARY."

To specify a variable instead of the actual password in the Owner Name field of the File Properties dialog, type an exclamation point (!) followed by the variable name. For example: !MyPassword.

2      These functions are supported but not recommended due to the lack of support in other file systems. NEXT and PREVIOUS post Error 33 if you attempt to read beyond the end of the file.

3      POINTER() returns a record number.

4      POSITION(file) returns a STRING(4). POSITION(key) returns a STRING the size of the key fields + 4 bytes.

5      The RECOVER switch must be "armed" at the beginning of your program in order to support transaction processing. See Driver Strings for more information on the RECOVER function.

6      LOGOUT has the effect of LOCKing the file. See also PROP:Logout in the Language Reference.

7      You cannot LOGOUT an aliased file and its primary file at the same time.

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

9      OEM conversion is not applied to BINARY MEMOs. The driver assumes BINARY MEMOs are zero padded; otherwise, space padded.

10     Prior to Clarion 2.003 in 16-bit programs under Microsoft operating systems, writes (ADD, PUT) did not correctly flush operating system buffers. This problem is corrected with Clarion 2.003 and higher, so that writes are slower but safer. To implement the pre 2.003 behavior, use STREAM and FLUSH.