Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dealing with multiple data access objects per bizobj!?
Message
 
To
07/03/2002 09:27:11
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00626647
Message ID:
00629637
Views:
32
Hi, Neil!

>>
B) Enclose each BO (Invoice and Invoice Lines) in a MM event object, as suggested by Jay van Santen higher in this thread.
<<

This is my favourite choice (by architectural reasons) - but I don't have practical experience <s> (I started last month working with MMF)!


>>
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.
<<

Please take notice of dealing with connections: If You want to use *one* backend transaction for updating *two* cursors, you have to use the same connection for both cursors (backend transactions are connection-bound!!!!) and you have to switch off automatic transactions by using SQLSETPROP( "Transactions", 2 ).

BTW: May be there is an corresponding feature in MMF - in this case Kevin will jumping in <vbg>!
SeBaFlu
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform