Re: ADO exception with character combination inside string...

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:4512c1a7@xxxxxxxxxxxxxxxxxxxxxxxxx
Have you tried this before doing advice? This problem comes from buggy
implementation of Delphi TParameters.ParseSQL and have nothing to do with
DB backend.

Buggy? It's a well known/documented feature that the colon is used to
separate/define parameters. What's not documented well is if you are
dynamically building the SQL and the colon maybe part of the string, then
you have to set the ParamCheck = False.

We use parameterized queries extensively and have had no problems with the
"buggy implementation". How extensively? I'm glad you asked..

<shameless plug>

http://www.midwayusa.com

- Majority of content is database driven
- 100% Delphi 6/WebBroker CGI/ISAPI
- ADO against MSSQL 2000 and 2005

</shameless plug>

krf


.

Relevant Pages

  • Re: VS 2005 beta 2 for free (or nearly free)
    ... But why would you use Delphi instead of VS.NET? ... I don't find D2005 Pro slow, buggy or bloated for Win32 development, once I ... I see no reason not to believe it will also become svelte in time. ...
    (borland.public.delphi.non-technical)
  • Re: Kylix is dead?
    ... > Delphi 2005: buggy, slow, non ergonomic, eats uncontrolled memory ...
    (borland.public.delphi.non-technical)
  • Re: Argh! Delphi 2005! Argh!
    ... > code has bug, code written in any language, using any technology. ... > Delphi 4 was really buggy and I'm pretty sure it didn't have a single ... > Also note that I'm not telling D2005 is buggy. ... Also with the memory leaks... ...
    (borland.public.delphi.non-technical)
  • Re: Delphi 2005 Update 1 not enough?
    ... > from the day i got my hands on it, and all the way from Delphi 1 thru ... Normal painless editing, normal painless package management, in my ... I also remember D2 being somewhat buggy in it's initial release. ...
    (borland.public.delphi.non-technical)