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 R
, 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
Thanks Martijn. Your suggestion worked perfectly