Hello, everyone

Suppose one has an invoice, stored in two tables. The data is stored in an SQL Server, and accessed throught two updateable remote views.

The 'Add invoice' process is issued as follows:

a) TABLEUPDATE(the_first_view)
b) handle = CURSORGETPROP('the_first_view,connecthandle')
c) SQLEXEC(handle,'SELECT @@identity AS nIdent','local_cursor')
d) SELECT the_second_view
e) REPLACE ALL invoice_id with local_cursor.nIdent
f) TABLEUPDATE(the_second_view)

I'd like to have this in a transaction.

Q: how to implement a transaction mechanism here and is there a way to rollback the first view if the second tablupdate() fails?


Hoping I made myself clear,