Re: ADO query parameters
From: David Wilcockson (dnw_at_librios.com)
Date: 01/11/04
- Next message: Dennis: "Re: Re: Delphi 8 - ADO?"
- Previous message: Chad: "Select * returns Unspecified Error, but Select ID WORKS ... HELP"
- In reply to: Bill Hannan: "ADO query parameters"
- Next in thread: Bill Hannan: "Re: ADO query parameters"
- Reply: Bill Hannan: "Re: ADO query parameters"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 11 Jan 2004 18:26:36 -0000
Try:
MyQuery.Parameters.ParamByName('MyField').Value
(Note that the TADOQuery component is not (currently?) supported in Delphi
8)
David
"Bill Hannan" <wfha@earthlink.net> wrote in message
news:4001514a$1@newsgroups.borland.com...
> Hi,
>
> I'm converting a bde app to ado (delphi 7, access 2000 format database).
Is
> there an equivalent to BDE paramByName? I can't seem to get it to work, I
> need to use query.parameters[int].value. That is much harder to read and
> in several queries it requires multiple assignments when a parameter
appears
> more than once.
>
> Bill
>
>
- Next message: Dennis: "Re: Re: Delphi 8 - ADO?"
- Previous message: Chad: "Select * returns Unspecified Error, but Select ID WORKS ... HELP"
- In reply to: Bill Hannan: "ADO query parameters"
- Next in thread: Bill Hannan: "Re: ADO query parameters"
- Reply: Bill Hannan: "Re: ADO query parameters"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]