Re: ADO exception with character combination inside string...
- From: "Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Sep 2006 08:53:00 -0500
When the ParamCheck is True, the query attempts to parse out parameters within
the SQL statement.
For example:
Query.SQL.Text :=
'Select * From MyTable '+
'Where ID = :AID' ;
The query will add a parameter called "AID". With ParamCheck set to False, it
will not attempt to parse out and add parameters. When your query saw the colon
it was trying to add a parameter. Why it only happened when there was double
quote involved, I don't know. I suspect a corner-case bug.
-Steve-
"Bo Berglund" <bo.berglund@xxxxxxxxx> wrote in message
news:4n94h2tvum5enb241cgelhf5s80cpc187p@xxxxxxxxxx
On Wed, 20 Sep 2006 20:03:18 -0500, "Steve Zimmelman"
<skz@xxxxxxxxxxxxxxxxxx> wrote:
Try setting:
AdoQuery.ParamCheck := False ;
-Steve-
THanks,
this seems to work.
Why does it happen???
/Bo
.
- References:
- ADO exception with character combination inside string...
- From: Bo Berglund
- Re: ADO exception with character combination inside string...
- From: Bo Berglund
- Re: ADO exception with character combination inside string...
- From: Steve Zimmelman
- Re: ADO exception with character combination inside string...
- From: Bo Berglund
- ADO exception with character combination inside string...
- Prev by Date: Re: Proper way of using ctDynamic cursortype on network with MS Access
- Next by Date: Re: Delphi 6 - ADO - MS SQL Server
- Previous by thread: Re: ADO exception with character combination inside string...
- Next by thread: Re: ADO exception with character combination inside string...
- Index(es):
Relevant Pages
|
|