Devart Forums

I use unidac with firebird.

I have an SQL which is a join on 2 tables.
eg.

SELECT *
FROM TABLE1 T1
JOIN TABLE2 T2
ON( T1.KEY = T2.KEY )

I need when I insert into this dataset and then post.

TABLE1 to be inserted into, then TABLE2 to be inserted into.

How can I do this?

I also want it to be as simple as possible.

After much investigation and trial and Error.
I have come up with a solution.

Use VIEWS and then use the triggers on the views to update the real tables.

Hello,

It's good to see that you found a solution. If any other questions come up, please contact us.