Re: [Firebird-net-provider] How to get Generator value

2006-11-06 Thread Pham Huu Le Quoc Phuc
Thanks for your reply, I will try it! Phucphlq -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of paha Sent: Monday, November 06, 2006 2:57 PM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] How to get Generator value

Re: [Firebird-net-provider] How to get Generator value

2006-11-05 Thread paha
If i've got what you mean, you should run this query with FbCommand.ExecuteScalar "select gen_id(my_global_generator_name,1) from rdb$database"- you will increase the generator value by 1, and get this new value at client -- View this message in context: http://www.nabble.com/How-to-get-Generat

Re: [Firebird-net-provider] How to get Generator value

2006-11-05 Thread Jiri Cincura
Pham Huu Le Quoc Phuc wrote: > Hi! > > I want to use Generator to create global Key for all record of all > table. I want to get value and Generator increase 1 at client. select gen_id(generator, 1) from rdb$database; -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.c

Re: [Firebird-net-provider] How to get Generator value

2006-11-05 Thread paul.mercea
-net-provider@lists.sourceforge.netSubject: [Firebird-net-provider] How to get Generator value Hi! I want to use Generator to create global Key for all record of all table. I want to get value and Generator increase 1 at client. How to do

[Firebird-net-provider] How to get Generator value

2006-11-05 Thread Pham Huu Le Quoc Phuc
Hi! I want to use Generator to create global Key for all record of all table. I want to get value and Generator increase 1 at client. How to do? - Using Tomcat but need to do more? Need to support web services,