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.