Re: [Firebird-net-provider] [firebird-support] Create Autoincrement

2017-03-25 Thread Mark Rotteveel
On 25-3-2017 15:09, Clyde Eisenbeis wrote: > I should have started this email with ... C# ... Firebird ADO.NET ... > FirebirdClient.5.8.0 ... Visual Studio 2013. > > I tried entering > > CREATE GENERATOR gen_t1_id; > SET GENERATOR gen_t1_id TO 0; > > set term !! ; > CREATE TRIGGER T

Re: [Firebird-net-provider] [firebird-support] Create Autoincrement

2017-03-25 Thread Clyde Eisenbeis
I should have started this email with ... C# ... Firebird ADO.NET ... FirebirdClient.5.8.0 ... Visual Studio 2013. I tried entering CREATE GENERATOR gen_t1_id; SET GENERATOR gen_t1_id TO 0; set term !! ; CREATE TRIGGER T1_BI FOR T1 in my C# code ... the compiler complains. This

Re: [Firebird-net-provider] [firebird-support] Create Autoincrement

2017-03-24 Thread Scott Morgan
On 03/24/2017 03:09 PM, Clyde Eisenbeis wrote: > Using http://www.firebirdfaq.org/faq29/ as a reference. > > 1) If I understand this website, the CREATE GENERATOR is initiated only once? Yes. It's a global item like a table, so you just need to create it once (and commit that change to the DB,. C

[Firebird-net-provider] [firebird-support] Create Autoincrement

2017-03-24 Thread Clyde Eisenbeis
Using http://www.firebirdfaq.org/faq29/ as a reference. 1) If I understand this website, the CREATE GENERATOR is initiated only once? 2) Likewise the CREATE TRIGGER is initiated only once? 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)? 4) I see the 'id' field in table t1. I see upper