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
