13.1.3 Related Features
- Jongeun Hur (Unlicensed)
In this section, you can find functions and subroutines frequently used for ODBC. Please refer to the table below for applicable functions/subroutines. For more detailed information of each function and subroutine, please refer to the next section.
Command | Description | |
Subroutine | CSqlOpen | Let the database manager execute the query and receive the result. |
Subroutine | CsqlClose | Closes the query in the database and ends the operation. |
Subroutine | CSqlDelete | Deletes the currently displayed record from the database manager. |
Subroutine | CSqlFirst | Transfers the topmost record data to the tag. |
Subroutine | CSqlGetRecord | Reads the data according to the assigned record number. |
Function | CSqlGetRecordNo | Returns the number of active records in the database manager. |
Subroutine | CSqlInsert | Inserts a new record to the database manager. |
Subroutine | CSqlLast | Reads the last record data from the database. |
Subroutine | CSqlNext | Reads the next record data. |
Subroutine | CSqlPrev | Reads the previous record data. |
Subroutine | CSqlReconnect | Reconnects to the DBMS in case of the disconnection. |
Subroutine | CsqlRequery | Executes the query again and reads the record data again. |
Subroutine | CSqlRun | Let the database manager execute the query. |
Subroutine | CSqlUpdate | Updates the record data from database manager with the current tag value. |
Subroutine | RawSqlRun | Executes the command in SQL statement to database. |
Function | CSqlGetError | You can find the error with the return value of the function. |