|
To script an application using
ADO to connect to a USoft Remote Rules Service API data source:
|
·
|
Use an ADODB.Connection object to establish a connection to a
pre-configured data source based on the "USoft Remote Rules
Services 8.0" driver. Refer to the required data source name as a
parameter of the ADO method Connection.Open(). |
|
·
|
Use ADODB.Command objects to create and execute SQL statements.
The SQL must be formulated in ODBC syntax, i.e., with the use of
question marks '?' for input parameters and the use of escape
characters '{' and '}' around scalar functions. |
|
·
|
Use ADODB.RecordSet object to fetch data. |
|
·
|
Use ADODB.Errors object to retrieve any rules engine violation
messages or error messages. |
|
