Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michel Levy
  Where is Michel Levy?
 
 France
 Michel Levy
 To: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 Tags
Subject: RE: transactions
Thread ID: 365353 Message ID: 365375 # Views: 45 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 25, 2012 3:34:37 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.

--
in addition to David, you can't know the locks put by other processes than yours, and how long they will stay.

Michel L

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