[Firebird-net-provider] Firebird web provider

2008-06-19 Thread Mercea Paul
Hi all I have few propositions about SP for web provider 1. In ROLES_ISUSERINROLE and ROLES_ISEXISTS is : SELECT first(1) 1 FROM table INTO :RES; I propose to change this to : IF (EXISTS(SELECT 1 FROM table)) then RES=1; 2 SQL Statement like : select first(

Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-19 Thread Carlos
Hello: > And so, that it´s imposible to do? > Right now yes, as all the "default" IsolationLevels are using the Wait option. -- Carlos Guzmán Álvarez Vigo-Spain - Check out the new SourceForge.net Marketplace. It's the be

Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-19 Thread Félix González
And so, that it´s imposible to do? Thanks _ De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Carlos Enviado el: jueves, 19 de junio de 2008 10:54 Para: For users and developers of the Firebird .NET providers Asunto: Re: [Firebird-net-provider] Transsactionscope NoWait

Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-19 Thread Carlos
Hello: You're right. I forgot, that's another "transaction" type. :( ;) -- Carlos Guzmán Álvarez Vigo-Spain - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about any

Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-19 Thread Jiri Cincura
On Thu, Jun 19, 2008 at 9:52 AM, Carlos <[EMAIL PROTECTED]> wrote: > You can't do that, what TransactionScope expects is an instance of > System.Transactions.Transaction class. You're right. I forgot, that's another "transaction" type. :( -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvo

Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-19 Thread Carlos
Hola: I try it bit I get a compilation error can´t convert > 'FirebirdSql.Data.FirebirdClient.FbTransaction' en > 'System.Transactions.Transaction'My code is: > > FbConnection cnm = CreaConexion(); > cnm.Open(); > FbTransaction tr = cnm.BeginTransaction(FbTransactionOptions.NoWait); > using (Trans

Re: [Firebird-net-provider] Transsactionscope NoWait

2008-06-19 Thread Félix González
I try it bit I get a compilation error can´t convert 'FirebirdSql.Data.FirebirdClient.FbTransaction' en 'System.Transactions.Transaction'My code is: FbConnection cnm = CreaConexion(); cnm.Open(); FbTransaction tr = cnm.BeginTransaction(FbTransactionOptions.NoWait); using (TransactionScope ts = new