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]
