Hi!
I am attempting to query an ole connected advantage database. If I
hard-code the criterion into the query, all is well.
However, if I attempt to pass the criterion as a parameter, using =:x the
following occurs: First I get a dialog box that allows me to enter a value
for x. Then, I get an error message that reads
"The data content could not be loaded. The provider cannot derive
parameter information from the command. Use SetParameterInfo."
The associated syntax in the SQL is WHERE ("JOURNAL"."Type" = :x)
I think it needs to know the data type of the parameter, perhaps. However,
I cannot find any documentation regarding SetParameterInfo or how to use it.
Additionally, if I attempt to pass the criterion as a parameter using = [x]
I do not get a dialog box at all, but instead when I run the query I get an
"Error 7200: AQE Error: State = S0000; NativeError = 2121; [Extended
Systems][Advantage SQL Engine]Column not found: x -- Location of error in
the SQL statement . . . . " etc. and it points to a location in the SQL
Statement where syntax is WHERE ("JOURNAL"."Type" = "x")
Can anyone provide some insight?
Jerry Thomason
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
