Applies to:
- Winshuttle Foundation
OLE DB Query plugin properties
The OLE DB Query plugin allows you to work with databases by creating, updating, and deleting database records.
Value Pair |
Description |
|
connectionstring |
String to use to connect to the database. |
|
escapesql |
A Yes/No value that indicates whether or not the plugins should escape apostrophes in the field values used in substitutions in the query supplied. The default is Yes if omitted. |
|
isstoredprocedure |
A Boolean expression indicating whether or not the value specified in the query argument is a database stored procedure. |
|
parameters |
A comma-separated list of parameters in the query. |
|
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. |
|
query |
The query string. |
|
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 SharePoint fields VendorName and Amount to the parameters in the query.