Syntax |
Example |
Description/Remarks |
Q_START
|
See sample template for Database Query commands |
This command will execute an SQL statement that returns a result set. It returns 1 if a command is successfully executed and 0 if an error occurs.(Note: if an update, insert, delete or other command is run, a return value of 1 doesn’t mean the insert worked; it only means that there were no errors in the statement.) Most commonly used to run a SELECT query or to execute a stored procedure that returns a result set. Q_START will automatically disconnect if already connected and will end query if one is open. Connection_number : 1-10. A template may have up to 10 distinct connections to external data sources. A separate text buffer is maintained for each connection.
To execute a stored procedure, consult your database documentation for the appropriate syntax. The simplest method of calling a stored procedure uses the following syntax:
|