Hi,
I haven't had any luck on the user forum getting an answer to this question.
Can you cc or reply to me if there is an answer, or if this is a bug?
Thanks!
----- Original Message -----
From: "Jerry Thomason" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2007 10:12 AM
Subject: [users] newbie having trouble passing parameters to a
query
> 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]
