[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