Syntax

Example

Description/Remarks

Q_START
connection_number,
"SQL statement"

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.