Can anyone tell me if its possible to create a cursor loop in a firebird trigger? If not can it be done using a SP and calling from the trigger?
The scenario is that I have 3 tables, A, B and C. A and B are master detail and C is a lookup for B. After an insert of a record into table A I want to selected all records in table C and insert them into table B, key being A (PK) + C (PK). Therefore I want an after insert trigger on A to insert a row in B for each row in C.
Hope this makes sense!!!