Syntax |
Example |
Description/Remarks |
Q_START
|
See sample template for Database Query commands |
Returns True=1 or False=0. Note: if an update, insert, delete or other command is run, a True doesn’ t mean the insert worked; it only means that there were no errors in the statement. 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 that does not return a result set, simply run the stored procedure. Depending on the database, the syntax may be different. For example, to run a stored procedure in Pervasive.SQL you type CALL <stored procedure name>. In Oracle, type EXEC <stored procedure name>. In Microsoft SQL Server, type EXEC <stored procedure name> or simply the name or the stored procedure with no keyword. |