SQL functions

Access functions are grouped together under the SQL functions in any ODBC data source:

f$SQLConnect	Make an ODBC connection (user or system DSN)
f$SQLDriverConnect	Make an ODBC connection (any DSN)
f$SQLDisconnect	End an ODBC connection
f$SQLConnectOpt	Set a connection option
f$SQLTransact	End a transaction with Commit or Rollback
f$SQLBindColumn	Assign parameters to table columns
f$SQLBindPG	Assign a parameter group to table columns
f$SQLExecute	Execute an SQL command
f$SQLRead	Read the next data record
f$SQLRead_to_pg	Read data to an indexed parameter group
f$SQLPG_to_string	Create an SQL command from a parameter group
f$SQLInsert	Create a data record from a parameter group
f$SQLUpdate	Modify a data record from a parameter group
f$SQLChrValue	Add a value to an SQL WHERE clause as a string
f$SQLNumValue	Add a value to an SQL WHERE clause as a number
f$SQLRowCount	Delivers the number of lines affected by the last SQL write command
f$SQLError	Get the description of the last ODBC error

Hint:

A more user-oriented and comfortable interface is available from the ePOS additional functions with functions for accessing database tables as well as functions for data exchange with SalesManager.

See also:

f$SQLConnect

f$SQLDriverConnect

f$SQLDisconnect

p$TDV:SMPAPI:Check_ODBC