DBmiscStatement performs a miscellaneous SQL operation on the current database.
statement string
process_statement int
connect_information DBconnectInformation group
dbvisual_descriptor ptr to a structure
db_specific_error_message string
db_specific_error_code int
statement_error_offset int
processing int
return_code int
DBmiscStatement performs a miscellaneous SQL operation on the current database. The operation is specified by the SQL statement that is entered.
If the specified statement performs operations that are typically managed as a transaction, DBquery starts a transaction if one has not already been started. To terminate the transaction, use DBcommit or DBrollback.
A pointer to the connection descriptor of the session in which DBquery is to execute. This is the output of the DBconnect module that initiated the session.
CAUTION: Do not modify this value. A fatal error will result.
An SQL statement other than the "CONNECT" statement.
The statement must be a complete, literal, SQL statement that includes all required keywords and all necessary input data values. It must NOT end with a semicolon. The maximum length allowed is 32K bytes.
A trigger that initiates execution of the SQL statement. When this value changes to a value greater than 0, the statement is executed.
An message that describes the status of the SQL operation.
Information about the current connection:
• the status of the connection: connected (1) or disconnected (0)
This parameter is of type DBconnectInformation. For more information, see DBconnectInformation .
CAUTION: Do not modify this value. A fatal error will result.
An error message returned by the database server when an error occurs during its processing of the SQL operation. For more information, see your database documentation.
An error code associated with the error message returned by the database server when an error occurs during its processing of the SQL operation. For more information, see your database documentation. A value of 0 indicates success; a nonzero value indicates failure.
A returned value indicating the position in the SQL statement where an error occurred. This value is returned only if the database server returns an error message indicating that the SQL statement is invalid.
This information is useful for constructing an error message; see DBerrorString .
A return value that indicates the processing status of the SQL operation. This value is set to 1 while the operation is being processed and is cleared to 0 to indicate that the operation has completed.
The status code associated with the message returned in the message parameter. A value of 0 indicates success; a nonzero value indicates failure.