Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dealing with multiple data access objects per bizobj!?
Message
 
À
07/03/2002 09:27:11
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00626647
Message ID:
00629637
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform