Executes a command available in Panther's database drivers
The command to execute, where
dbmsStmtcan include one of the following:
dbmscommand executes the specified command after colon expansion and syntax checking. These commands control the connections to database engines, process information fetched in
SELECTstatements, and update database information. For information on available commands, refer to Chapter 11, "DBMS Statements and Commands."
There are two methods of passing SQL statements to the database engine. DBMS QUERY and DBMS RUN pass the statement directly to the database engine. DBMS DECLARE CURSOR creates a named cursor to use for executing the SQL statement. For more information, refer to Chapter 28, "Writing SQL Statements," in Application Development Guide.
Because each database engine has unique features, refer to Database Drivers for information about database-specific features and commands.
Additional forms of colon expansion–colon plus processing and colon equal processing—are available with the
dbmscommand to help format information before passing it to the database engine. For more information, refer to Chapter 29, "Reading Information from the Database," in Application Development Guide.
// Fetch next set of rows
dbms continue// Commit transaction
dbms commit// SQL statement
dbms QUERY select * FROM titles WHERE title_id = :+title_id