Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Updated documentation on parameters. (Read 2805 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Updated documentation on parameters.
02.06.08 at 09:48:55
 
Updated documentation on parameters.
 
The documentation on parameters was updated.  Examples were still given with an older syntax. The Parameters.Items collection was replaced a while ago with 2 collections, one for each parameter type, Parameters.BindVariables and Parameters.SubstVariables.
 
Please see:
http://www.oraxcel.com/projects/sqlxl/help/vba/SQLXL/Database/Parameters/index.h tml
http://www.oraxcel.com/projects/sqlxl/help/vba/SQLXL/Database/Parameters/Paramet er/index.html
 
After setting the SQL text to the SQL object the collections will be updated. So if your statement is as follows the Parameters.Bindvariables collection will be containing the au_id parameter:
SQLXL.Sql.SetText "select * from authors where au_id< :max_au_id
 
Next the value or other properties of the parameter can be set. Suppose we want to run with a value of 100 we can now set the parameter value:
SQLXL.Database.Parameters.BindVariables("max_au_id").Value = 100
 
Note that the parameters collection is part of the database object. The parameters will be defined for the duration of the database connection.
Back to top
 
« Last Edit: 02.06.08 at 09:50:47 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1