Index of available Commands

Applies to

SQLBat   (Module: SQLBatX.dll)

Command	Description
CLEARROW	Clear row data
CLOSESQLQUERY	Close open query/recordset
CONNECT	Open connection to a database
DISCONNECT	Close connection to a database
EXITROWLOOP	Cancel further processing of a resultset
GOTONEXTROW	Jump to next record
ISDBEOF	Checks if the end of a recordset has been reached
LOOPSQLRESULTS	Loop through the resultset of an SQL query
OPENSQLQUERY	Open an SQL query
READROW	Read current row from database to column collection
REMOVECOLUMN	Delete a column from column collection
SETCOLUMN	Set the value of a column in the column collection
SETDBOPTION	Set an option for a database connection
SETMDB2KODBCCONSTR	Generate connection string for connection to Access 2000 MDB
SETMDBFILECONSTR	Generate connection string for connection to Access 97 MDB
SETMDBODBCCONSTR	Generate connection string for connection to Access 97 MDB via ODBC
SETMSSQLODBCCONSTR	Generate connection string for connection to MS SQL Server database via ODBC
SETMYSQLODBCCONSTR	Generate connection string for connection to MySQL database via ODBC
SQLEXEC	Perform SQL statement on open connection
USINGDB	Set currently used database connection
VIEWDBOPTIONS	View currently set options
VIEWROW	View row data

Further available all wmACScr1 commands.