From: Stacey Verner [mailto:[EMAIL PROTECTED]]
> I wanted
>
> select :param, field
> from table
>
> to be the same as
>
> select "bob", field
> from table
>
> Alas, this is not the way it works.
Actually, it does work in LocalSQL. Try the following with a TQuery
(DBDemos database):
select name, :param1
from animals.dbf
// Set datatype of param1 to integer and paramtype of param1 to input,
then
query1.parambyname('param1').asinteger := 1;
query1.open;
// Angel Fish 1
// etc.
I raised this same problem a while ago on one of the Interbase newsgroups
because I thought it was specific to a TIBSQL (an IBX beastie). Got no
solution though. :-(
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
