I recommend you that you update to 2.5.2 and that it makes a test of concept
with the ' and ''

Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: "Ricardo Uzcategui" <ricardouven@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, September 30, 2010 3:48 PM
Subject: Re: [firebird-support] Unexpected "a string constant is delimited
by double quotes" exception


> Maybe is the provider!!!
> or global variable stack of provider!
>
>
> 2010/9/30 fernnaj <yo@...>
>
>>
>>
>> Hello everyone,
>>
>> I am using Firebird 2.1.3 Windows x86, and Firebird Provider for .NET
>> 2.5.1.0.
>>
>> I have had a strange error a couple of times in the last month, in two
>> different computers.
>>
>> For some reason, at a certain moment, and impossibly to reproduce, a
>> query
>> (that has been executed thousand times before and that will be executed
>> later on without problems) suddenly provokes this error:
>>
>> FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
>> SQL error code = -104
>> a string constant is delimited by double quotes
>> at
>> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
>> behavior)
>>
>> The query is this:
>>
>> SELECT PMH.PMH_A PMH_A,PMH.PMH_B PMH_B,PMH.PMH_C PMH_C,PMH.PMH_D
>> PMH_D,PMH.PMH_E PMH_E,PMH.PMH_F PMH_F,PMH.PMH_G PMH_G,PMH.PMH_H
>> PMH_H,PMH.PMH_I PMH_I,PMH.PMH_J PMH_J FROM "PMHTABLE" PMH WHERE
>> (PMH.PMH_E=@string0 AND (PMH.PMH_C=@guid0 OR PMH.PMH_C IS NULL)) ORDER BY
>> PMH.PMH_D ASC
>>
>> The connection string uses dialect 3, character set UTF8 and packet size
>> 8192 (the same as the database).
>>
>> As I say, this query always runs without problems, except for this
>> particular time that it failed.
>>
>> I don't know what the problem can be - especially, because I cannot
>> reproduce it. I use parameters, so there should be no problems with
>> quotes... why is it saying "a string constant is delimited by double
>> quotes"? And, if there is a problem, why doesn't it say it always?
>>
>> Thanks in advance for any help.
>>
>> Regards, Fernando
>>
>>
>>
>
>
>
> --
> Ricardo...
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>