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 appears to not be relevant for C#. What I need is the ability to add data and retrieve the primary key which needs to be autoincremented ... see http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable for the current code. On Fri, Mar 24, 2017 at 10:57 AM, Scott Morgan <bl...@blueyonder.co.uk> wrote: > 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,. Changes to tables and other global > items like that all need to be committed before using them). It'll have > an initial value of 0 and calls to GEN_ID will increment it by the > specified value (usually 1) > >> 2) Likewise the CREATE TRIGGER is initiated only once? > > Yes. It's just associated with the table, ready to run whenever the > specific event happens, so... > >> 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)? > > The "ACTIVE BEFORE INSERT POSITION 0" specifies that. In this case > 'BEFORE INSERT', so whenever a new item is inserted into the table, that > trigger is run. > >> 4) I see the 'id' field in table t1. I see upper case 'ID' in the >> TRIGGER. Are these two the same? > > Yes. (Bit of bad form in that FAQ there I'd say, mixing case) Unquoted > identifiers (names of tables, columns, etc.) are stored in upper case. > So id, ID, iD, and Id are all the same (ID). > > > You'll get more detailed answers about this stuff on the main Firebird > mailing list, and I highly recommend the Firebird Book by Helen Borrie, > which covers all this clearly and in depth. It's things like triggers > and foreign keys that make a proper DB so powerful, but it can take a > bit of getting used to. > > Scott > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider