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

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


.

Relevant Pages

  • Re: Library Cache
    ... procedures that determines the SQL to be submitted based on the ... query string to parse, whereas: ... it's HOW and WHEN that replacement occurs. ...
    (comp.databases.oracle.server)
  • Re: help pulling data from a query
    ... our scanners will only scan the data not hit return so i was ... that the query just returns the scanned units. ... if the battery should be replaced again or not. ... then parse that string to find each serial number. ...
    (microsoft.public.access.forms)
  • Re: Need help with query linked to form.
    ... Format() is guaranteed to create a Text field. ... You generally do need to parse the dates so Access knows how to interpret them. ... I have never used the CVDate() function though. ... do you use a Make Table query? ...
    (microsoft.public.access.queries)
  • Re: Oracle 10g and DBD::Oracle
    ... executed the following query to give me the total parse and hard parses ... before and after my query block. ... The above SQL Block creates only 1 cursor not 2. ... same sql query when I execute a SELECT statement via my small little perl script. ...
    (perl.dbi.users)
  • Identify/parse content within documents?
    ... I've got a full-text index on a table in which I've got word docs and ... I want to parse out certain types of content from these ... document yielded by a query. ... the client would input a ...
    (microsoft.public.sqlserver.fulltext)