RE: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?

2015-03-16 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
HI Louis, It's pretty cool, but i need only in SQL, that too same number for all records for same employee and next incremental number for all records of the another employee. SET any help offered ? The first thing that comes to mind, is EXECUTE BLOCK (which is basically a STORED PROCEDURE

RE: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?

2015-03-14 Thread 'Louis van Alphen' lo...@nucleo.co.za [firebird-support]
Of course, using get_context and set_context is a great way to implement true multi-tenancy at DB level in Firebird. Multi-tenancy can be dangerous if implemented in middleware or SQLs because programmers make mistakes and can forget a where clause. What we want to do is to have the DB abstract

Re: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?

2015-03-13 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 13 March 2015 01:58 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] How To Generate Auto Increment Number in SQL Itself ? Hi All, I have one question, any SQL I write, I would like to get