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 generator value before insert.
Anyway, I need this value cause the record inserted will be often updated
during an execution cycle.
I've been thinking about another solution, but it's not exactly ideal:
1) Insert a unique value in another field with the insert.
2) Use a simple query like this: Select ID from tblThis where
myUniqueField = :MyUniqueValue;
3) Use the id from this query to work with the record from there.
This will probably work, but there has to be a better and faster way.
Best wishes
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Norway
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Mercea Paul
Sent: 8. mai 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 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 provider to work with a
Firebird generator
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 have all the dataaccess in a separate layer (DLL)
using the DDEX provider, I would like to keep this in a tableadapter. But
the queryanalyser chokes on the $ sign in rdb$database. And if I include the
name in " like this "rdb$database" it will find the table but only 4 - 5
columns. The generators are not there. I could use a FBCommand through code
to get passed the queryanalyser, but then I met other problems.
Any help are greatly appreciated.
Thanks in advance.
Best wishes
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Norway
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
