Tips   >   Functions   >   Sys Functions - Database

Sys Functions - Database

This section provides you with documentation, tips, and demos for each of data file and database related the sys() functions.

sys(81) Search name

Returns the current search name (empty if no search set).

sys(82) Main file name

Returns the main file name (empty if no main file set).

sys(83) Records in main file

Returns the number of records in main file.

sys(130) Server name

(Old DAMS only) Returns the server name for the current session.

For example, 'Oracle version [1.2 r0]' (empty if no server connected).

sys(131) SQL error code

(Old DAMS only) Returns the SQL error code, or 0 for no error.

sys(132) SQL error text

(Old DAMS only) Returns the SQL error text for the current error code (empty if not available).

sys(133) SQL select table # columns

(Old DAMS only) Returns the number of columns for the current Select table.

sys(134) SQL rows processed

(Old DAMS only) Returns the number of rows processed by the previous Insert, Delete, or Update statement, returns 0 for most other statements.

; Notation equivalent in table class method
Do $cinst.$rowsaffected() Returns Num

sys(135) SQL rows fetched

(Old DAMS only) Returns the number of rows fetched from the Select table.

; Notation equivalent in table class method
Do $cinst.$rowsfetched() Returns Num

sys(136) SQL current cursor

(Old DAMS only) Returns the name of the current cursor.

sys(137) SQL current session

(Old DAMS only) Returns the name of the current session.

sys(138) SQL results sets

(Old DAMS only) Returns the number of Result sets to come back from the server following a Select. Returns 0 if no more results.