DBinsert inserts a row of data into a table in 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
DBinsert inserts a row of data into a table in the current database by executing a SQL INSERT statement. The data values inserted are specified in the predicates of the INSERT statement.
DBinsert 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.
A SQL INSERT statement. This 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 INSERT statement. When this value changes to a value greater than 0, the statement is executed.
An message that describes the status of the insert. For a list of possible values, see The Toolkits Book.
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 insert. 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 insert. 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 INSERT statement where an error occurred. This value is returned only if the database server returns an error message indicating that the INSERT statement is invalid.
This information is useful for constructing an error message; see DBerrorString .
A return value that indicates the processing status of the insert. This value is set to 1 while the insert is being processed and is cleared to 0 to indicate that the insert 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. For a list of possible values, see ."
•