Re: [DUG]: Query Parameters

[Steve Peacocke]

On Wed, 18 Oct 2000 11:14:15 +1300 Stacey Verner wrote:
> select :param, field

> from table



Perhaps this was a typo but you cannot specify a param on a query in
anything but a value. Tha above will produce an error.



I've deleted the earlier post where you had the full query, but I think it
was an insert query..



Insert into Blah (Field1, :Param1) values (...



would not work, but..



Insert into Blah (Field1, Field2) values (:Param1, :Param2)



..WOULD work. You are attempting to parameterise the field names themselves
which is, as I understand it, a no-no.



Steve

---------------------------------------------------------------------------
    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"