firebird-net-provider

[Firebird-net-provider] How insert double quotes between simple quotes?

[Cristiano A. C. <cri...@te...>]

Hi,

How insert double quotes between simple quotes?
This SQL Command
   select * from usuarios where band = 'Guns''n''Roses'
show me a error:

FirebirdSql.Data.Firebird.FbException: Dynamic SQL Error
SQL error code = -104
Unexpected end of command
---> FirebirdSql.Data.Firebird.Gds.GdsException: Exceção do tipo 
FirebirdSql.Data.Firebird.Gds.GdsException foi acionada.
   at FirebirdSql.Data.Firebird.Gds.GdsAttachment.ReadStatusVector()
   at FirebirdSql.Data.Firebird.Gds.GdsAttachment.ReceiveResponse()
   at FirebirdSql.Data.Firebird.Gds.GdsStatement.Prepare()
   at FirebirdSql.Data.Firebird.FbCommand.InternalPrepare()
   at FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior 
behavior)
   --- Fim do rastreamento de pilha de exceções internas ---
   at FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior 
behavior)
   at 
FirebirdSql.Data.Firebird.FbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior 
behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, 
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand 
command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at CasadaSaude.BuscaCep.PorEndereco(String sEndereco, String sCidade, 
String sUF) in c:\Inetpub\wwwroot\csws\buscacep.asmx.cs:line 163

Someone idea?

-- 
Cristiano A. Costa é web developer e fundador do grupo Software Livre MS.
Software Livre MS
www.grupos.com.br/grupos/softwarelivrems
e-mail: cri...@te...
uin: 101778772

Re: [Firebird-net-provider] How insert double quotes between simple quotes?

[<car...@te...>]

Hello:

> How insert double quotes between simple quotes?
> This SQL Command
>   select * from usuarios where band = 'Guns''n''Roses'
> show me a error:

At this moment, for the limitations on the batch query execution, using 
parametrized querys.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] How insert double quotes between simple quotes?

[Peter J. <pj...@wa...>]

Hi All!

> > How insert double quotes between simple quotes?
> > This SQL Command
> >   select * from usuarios where band = 'Guns''n''Roses'
> > show me a error:
> 
> At this moment, for the limitations on the batch query execution, using
> parametrized querys.

Wouldn't one of these methods work:
(from MSDN)

<cite>
and can contain any character literal, including escape sequences:
string a = "\\\u0066\n";  // backslash, letter f, new line
Note   The escape code \udddd (where dddd is a four-digit number) 
represents the Unicode character U+dddd. Eight-digit Unicode escape codes 
are also recognized: \udddd\udddd.
[...]
The advantage of @-quoting is that escape sequences are not processed, 
which makes it easy to write, for example, a fully qualified file name:
@"c:\Docs\Source\a.txt"  // rather than "c:\\Docs\\Source\\a.txt"
To include a double quotation mark in an @-quoted string, double it:
@"""Ahoy!"" cried the captain." // "Ahoy!" cried the captain.
</cite>

I think, the complicated case would be single quotation marks.

Regards,
Peter Jacobi

Re: [Firebird-net-provider] How insert double quotes between simple quotes?

[<car...@te...>]

Hello:

> How insert double quotes between simple quotes?
> This SQL Command
>   select * from usuarios where band = 'Guns''n''Roses'
> show me a error:

I have added a change into the CVS, that i think will fix this,
if you want to test it, you get a copy of the CVS sources or replace the 
regex used in the FbCommand.splitBatchCommands method by this:

	"([^';]+('.*'))*[^';]*(?=;*)"





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain