Neil,
>transaction. Please correct me on this if I'm wrong, but I'm assuming that we'd have to use SQL Passthrough to make sure both cursors are updated correctly, or rolled back if there's an error. Anyway, that's not the question.
IMO you don't have to use SPT. All data access classes have methods called BeginTransaction() etc. For views take a look at the cDynamicViewCursor class. Additionally you must set your views to share connections. I'm not sure, but I think you have to use the connection manager class as well.
HTH,
Armin