ParamByName doesn't works?

Guillermo Casta?o

Delphi Developer

Fri, 09 Jan 2004 09:26:03 GMT

ParamByName doesn't works?

Hi, i want to know if there are limitations or malfunction of the
ParamByName property of Delphi using ADO.
thanks
--
Guillermo Casta?o Acevedo <SIRIO>
Guiller...@GrupoMillennium.com
Guillermo...@Hotmail.com
WWW: http://www.GrupoMillennium.com (Gerente de Sistemas)
Systems and Computers Engineer

Vassil Nazaro

Delphi Developer

Fri, 09 Jan 2004 11:58:30 GMT

Re:ParamByName doesn't works?

Quote

> Hi, i want to know if there are limitations or malfunction of the
> ParamByName property of Delphi using ADO.

I haven't had problems with that so fare.

--
Vassil Nazarov
http://web.orbitel.bg/vassil/

Ross

Delphi Developer

Fri, 09 Jan 2004 22:13:15 GMT

Re:ParamByName doesn't works?

I have had problems using parambyname.
I switched to using params instead
use it like this
TADOQuery1.params[0].value := SomeValue;

HTH
Ross

Guillermo Casta?

Delphi Developer

Sat, 10 Jan 2004 03:45:26 GMT

Re:ParamByName doesn't works?

It fixed with the ADOExpress upgrade

Quote

Vassil Nazarov wrote:
> > Hi, i want to know if there are limitations or malfunction of the
> > ParamByName property of Delphi using ADO.

> I haven't had problems with that so fare.

> --
> Vassil Nazarov
> http://web.orbitel.bg/vassil/

--
Guillermo Casta?o Acevedo <SIRIO>
Guiller...@GrupoMillennium.com
Guillermo...@Hotmail.com
WWW: http://www.GrupoMillennium.com (Gerente de Sistemas)
Systems and Computers Engineer

Brian Bushay Team

Delphi Developer

Sat, 10 Jan 2004 22:36:33 GMT

Re:ParamByName doesn't works?

Quote

> i want to know if there are limitations or malfunction of the
>ParamByName property of Delphi using ADO.

Do not use the same parameter name more than once in your SQL
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. ADO Query parameters: ParamByName doesn't work correctly

2. Parambyname doesn't work.

3. WORKING DIRECTORY: Doesn't work

4. Post doesn't work with Indy, works with ICS

5. why filecopy(string,'test.txt',err) doesn't work

6. TQuery's locate method doesn't work properly

7. Query.ParamByName('Foo').AsMemo ?

8. ParamByname('Time').DataType:=ftTime problem

9. D5: ParamByName('Fld').Clear is NoGo

10. Turbo Pascal for Windows doesn't quite work w/ Win 95