ADO Parameter problem
Hi !
I've just switched from FR 2.54 to 3.22 and im doing some tests and i have a little problem with parameters in a TfrxADOQuery connected on a SQL Server DB.
I'm doing a simple query like 'SELECT * FROM CUSTOMERS WHERE NO=:PARAM'
where NO is a varchar(15). When i'm trying to assigned a value to the parameter, FR throw me an error : 'Arguments are incorrect, out of bound or in conflict with something else' (this is a transcription from french...
).
But when i try to use an integer / boolean (bit) -typed column, everything is working good, even when i'm connecting an edit control / checkbox as the value for the parameter, like said in the help.
Is this a bug with this release ? Can i use parameters on a string column ?
I've tried to convert the value as a string, use a variable, nothing is working.
And this feature works fine in version 2.5x
plz help
I've just switched from FR 2.54 to 3.22 and im doing some tests and i have a little problem with parameters in a TfrxADOQuery connected on a SQL Server DB.
I'm doing a simple query like 'SELECT * FROM CUSTOMERS WHERE NO=:PARAM'
where NO is a varchar(15). When i'm trying to assigned a value to the parameter, FR throw me an error : 'Arguments are incorrect, out of bound or in conflict with something else' (this is a transcription from french...
).But when i try to use an integer / boolean (bit) -typed column, everything is working good, even when i'm connecting an edit control / checkbox as the value for the parameter, like said in the help.
Is this a bug with this release ? Can i use parameters on a string column ?
I've tried to convert the value as a string, use a variable, nothing is working.
And this feature works fine in version 2.5x
plz help