Re: [firebird-support] storing a sequence value in a trigger

2015-10-06 Thread talorigo...@yahoo.co.uk [firebird-support]
Thanks Martijn. Your suggestion worked perfectly

[firebird-support] storing a sequence value in a trigger

2015-10-06 Thread G G talorigo...@yahoo.co.uk [firebird-support]
I have three tables Guidance, Assignment and Review.  Assignment is a detail table to Guidance and Review is a detail table to Assignment.  When a new record is entered into the Guidance table I want to an after insert trigger on the Guidance table  to insert default values into Assignment and

Re: [firebird-support] storing a sequence value in a trigger

2015-10-06 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, October 06, 2015 1:30 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] storing a sequence value in a trigger I have three tables