Dan,
Thanks for that idea, I'll try it!
Jerry
----- Original Message -----
From: "Dan Lewis" <[EMAIL PROTECTED]>
To: <users@openoffice.org>
Sent: Saturday, May 12, 2007 5:46 AM
Subject: Re: [users] newbie having trouble passing parameters to a query
On Friday May 11 2007 9:42 pm, Jerry Thomason wrote:
I'm starting to feel unwanted. I've posted my question twice, with
not a single response. Others get responses almost immediately.
Is my newbie question perhaps not such an easy one to answer?
Someone please give me some feedback on this problem. Thanks!
(in advance)
Perhaps no one knows the answer to your question. And sorry, but
your question is far above the "newbie" range. You might get an
answer if you sent it to [EMAIL PROTECTED] and asked to be CC'd.
Dan
----- Original Message -----
From: "Jerry Thomason" <[EMAIL PROTECTED]>
To: <users@openoffice.org>
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]
-------------------------------------------------------------------
-- To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
