Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 To: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 Tags
Subject: RE: transactions
Thread ID: 365353 Message ID: 365374 # Views: 42 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 25, 2012 3:06:48 PM         
   


> >
> > --
> > Why? on the server or on the client?
> > what did other clients may read if you don't embed the 2 commands in a single transaction? some parent lines without childs?
> >
> > Michel L
>
> I think parent has only one record to update and child many records.
> I think Parent take less time to check for Success or fail.
>
>
> Warm Regards,
> mk.

Keep in mind though that the essence of transactions is "all or none at all", then as long as error handling is appropriate the order of child or parent is of much less importance if not to say irrelevant.

David
..
.

ENTIRE THREAD

transactions Posted by rupesh sharma @ 12/25/2012 7:35:21 AM
RE: transactions Posted by anand kulkarni @ 12/25/2012 8:32:38 AM
RE: transactions Posted by David Mustakim @ 12/25/2012 11:59:07 AM
RE: transactions Posted by anand kulkarni @ 12/25/2012 12:11:54 PM
RE: transactions Posted by Anil Sharma @ 12/25/2012 10:06:06 AM
RE: transactions Posted by David Mustakim @ 12/25/2012 11:45:25 AM
RE: transactions Posted by Anil Sharma @ 12/25/2012 12:50:09 PM
RE: transactions Posted by Rick Hodgin @ 12/25/2012 12:07:20 PM
RE: transactions Posted by Michel Levy @ 12/25/2012 12:56:08 PM
RE: transactions Posted by rupesh sharma @ 12/25/2012 4:13:08 PM
RE: transactions Posted by mk sharma @ 12/25/2012 1:05:19 PM
RE: transactions Posted by Michel Levy @ 12/25/2012 1:57:18 PM
RE: transactions Posted by mk sharma @ 12/25/2012 2:29:14 PM
RE: transactions Posted by David Mustakim @ 12/25/2012 3:06:48 PM
RE: transactions Posted by Michel Levy @ 12/25/2012 3:34:37 PM