Forum Discussion
Paginated Reports, Not all variables bound
Hi
instead of using :Parametername, use ? (Question Mark). Usually ODBC look for ? wherever you need to define the parameters.
SELECT
*
FROM <table_1>WHERE <field_1> BETWEEN ? AND ?
AND (<field_2>=? or <field_3>= ? or <field_4>=? or <field_5>= ?);Map the ? with appropriate variables in Parameters section of the dataset.
Thanks
Hari
Solution SageHi
instead of using :Parametername, use ? (Question Mark). Usually ODBC look for ? wherever you need to define the parameters.
SELECT
*
FROM <table_1>
WHERE <field_1> BETWEEN ? AND ?
AND (<field_2>=? or <field_3>= ? or <field_4>=? or <field_5>= ?);
Map the ? with appropriate variables in Parameters section of the dataset.
Thanks
Hari
Hi Hari,
Bless you, that worked.
It works.
My question is how it knows to map the ? question to the correct parameter.
Thank you Hari
