Re: [Firebird-net-provider] Issue with .net provider to work with a

2007-05-08 Thread Carlos Guzmán Álvarez
Hello: > So far so good. Since I have all the dataaccess in a separate layer > (DLL) using the DDEX provider, Hope you mean the ado.net provider. > I would like to keep this in a > tableadapter. The Visual Studio wizard performs some type of query parsing that is not valid for Firebird an

Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-08 Thread Mercea Paul
viders' Subject: Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator Hi Paul. >Why you need to know generator value before insert? I actually need the generator value after insert, but read in the firebird faq that it was a lot safer to get the

Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-08 Thread Kai Bohli
2007 13:13 To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator Why you need to know generator value before insert? Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROT

Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-08 Thread Mercea Paul
Why you need to know generator value before insert? Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kai Bohli Sent: Monday, May 07, 2007 9:17 PM To: For users and developers of the Firebird .NET providers Subject: [Firebird-net-provider] Issue with .net

[Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-07 Thread Kai Bohli
Hi all ! I have an existing table which I cannot change. That is, I cannot create a on before insert trigger on it. I have to know the generator value before insert so I have to run something like this: SELECT gen_id(GEN_WEBOBJECTNR, 1) AS id FROM rdb$database So far so good. Since I ha