Hi
Whay not two separate "update or insert” for parent and child?
You can use „merge” for massive „"update or insert” on single table.
Regards,
Karol Bieniaszewski
01.12.2019 04:56, dmil...@amfes.com [firebird-support] wrote:
> As I said - I can do this via stored procedures - but is there a way to do it
> without?
If you want to insert records to two tables with single query - you cannot.
If you don't want to use a stored procedure then the closest
dmil...@amfes.com [firebird-support] a écrit :
> That's just an "anonymous" procedure. I suppose it is technically something a
> client can run without having to define it in the database first - but I was
> hoping for something using just insert & select.
I do not understand English enough to