ODBC functions

These functions are used interact with an external database via Open Database Connectivity (ODBC).

Note: These functions are provided to support legacy database interfaces. In most cases, we recommend that you use the newer Database/ERP connections manager and functions.
  • ODBCBeginTrans
    Begins a transaction with the connected data source.
  • ODBCBindCol
    Binds a column to a tag.
  • ODBCCanAppend
    Returns whether the database will allow you to add new records.
  • ODBCCanTransact
    Returns whether the database allows transactions.
  • ODBCCanUpdate
    Returns whether the database can be updated.
  • ODBCClose
    Closes a connection to the database.
  • ODBCCommitTrans
    Commits a transaction. Call this function upon completing transactions.
  • ODBCDelete
    Deletes the current record.
  • ODBCExecuteSQL
    Directly executes an SQL statement.
  • ODBCInsert
    Inserts a new record in the database.
  • ODBCIsBOF
    Returns whether you have gone above the first record of the record set. (Call this function before scrolling from record to record.)
  • ODBCIsDeleted
    Reports whether the current record was deleted.
  • ODBCIsEOF
    Reports whether you have gone beyond the last record of the record set. (Call this function as you scroll from record to record.)
  • ODBCIsFieldNULL
    Reports whether a specified field in a record set was flagged as NULL.
  • ODBCIsFieldNullable
    Reports whether a specified field is nullable (i.e., can be set to a NULL value).
  • ODBCMove
    Moves the current record pointer within a record set, either forward or backward.
  • ODBCMoveFirst
    Moves to the first record within the record set.
  • ODBCMoveLast
    Moves to the last record within the record set.
  • ODBCMoveNext
    Moves to the next record within the record set.
  • ODBCMovePrev
    Moves to the next record within the record set.
  • ODBCOpen
    Opens a connection to the database and returns a numeric handler to be used by other ODBC functions.
  • ODBCQuery
    Retrieves the currently selected record from a database.
  • ODBCRollBack
    Reverses the changes made during a transaction.
  • ODBCSetFieldNULL
    Flags a field data member in the record set as NULL (specifically having no value) or as non-NULL.
  • ODBCSetFilter
    Constrains the records selected in a database.
  • ODBCSetSort
    Sorts the records selected in a database.
  • ODBCUnbindCol
    Unbinds a column that was previously bound using the ODBCBindCol function.
  • ODBCUpdate
    Updates the current record.
InduSoft Web Studio -Technical Reference

ODBC functions