Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 To: Michel Levy
  Where is Michel Levy?
 
 France
 Michel Levy
 Tags
Subject: RE: transactions
Thread ID: 365353 Message ID: 365372 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 25, 2012 2:29:14 PM         
   


> >
> > Always Update Parent table first, then your child table.
> >
> > Warm Regards,
> > mk.
>
> --
> 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.

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