| Purpose | The <dbstatement> statement is used to execute a SQL statement on a database via a created connection. This first implementation of the Superx++ run-time engine for Microsoft Windows uses an ODBC connection for this. | |||||||||||
| Format |
<dbstatement connection="{conn name}"> <parm type="{parm type}" name="{parm name}"> {parm value} </parm> <sql>{sql stmt}</sql> </dbstatement> {conn name} |
the name of the connection object to be used for the execution of the SQL statement |
{parm type} |
(optional) the datatype of the parameter to be substituted into {sql stmt} |
{parm name} |
(optional) the name of the parameter to be substituted into {sql stmt} |
{parm value} |
(optional) the value of the parameter to be substituted into {sql stmt} |
{sql stmt} |
the SQL statement to be executed on the database |
|
|
| Example #1 |
<dbstatement name="MyDbConn">commit;</dbstatement> performs a COMMIT statement on a database via the connection MyDbConn that was created using the <dbconnect> statement. |
|||||||||||