Hello,

As Ricardo suggests, I thought that the problem could be the provider, but I brought it to this list just to know what the message is supposed to mean.

I have updated our provider to 2.5.2. As we cannot replicate the problem at will, we can just hope that it will prevent the problem (whatever it may be) to happen again.

Regards, Fernando

--- In firebird-support@yahoogroups.com, "Ismael L. Donis García" <ismael@...> wrote:
>
> 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
> >
> >
> >
>