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: 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)
  • Re: Need help creating temporary table from filter
    ... So, now that I have the data for the email messages, I'm planning on using ... For Each/Next to parse through the records to create/send the messages. ... Marsh said elsewhere in this thread, you can probably use the query ... the same way as you were using tblTemp*. ...
    (microsoft.public.access.formscoding)
  • Re: History Replacement And New Location Combined
    ... // Parse the form and add parameters to the current location.search ... // Parse the query and fill out the form ... requests, giving the replace request a full second to execute. ... Not sure what you mean by "synchronize", ...
    (comp.lang.javascript)