OLE DB Query Plug-in Properties

The OLE DB Query plug-in allows you to work with databases by creating, updating, and deleting database records.

Value Pair	Description	Mandatory
connectionstring	ODBC connection name to the database. This should be a from Connection defined globally or for that app only.	Yes
escapesql	A Yes/No value that indicates whether or not the plug-ins should escape apostrophes in the field values used in substitutions in the query supplied.  The default is No.	No
isstoredprocedure	A Boolean expression indicating whether or not the value specified in the query argument is a database stored procedure.	No
parameters	A comma-separated list of parameters in the query.	No
parametertypes	A comma-separated list of parameter types in the query.  Can be one of int16, uint16, int32, uint32, int64, uint64, decimal, double, bool, single, float, date, datetime, or string.	No
query	The query string.	Yes
values	A comma-separate list of values to bind to the parameters.

Example

• connectionstring – Provider=sqloledb;Data Source=myServer;Initial Catalog=myDatabase;User Id=svadmin;Password=sharevis;
• isstoredprocedure – false
• parameters – @vendorcolumn,@vendoramount
• parametertypes – string,double
• query – select * from Invoices where vendor = ? and amount < ?
• values – [VendorName],[Amount]

This example queries the database specified by the connection string.  It runs the query specified against the database, and binds the values in the fields VendorName and Amount to the parameters in the query.