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: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 Tags
Subject: RE: transactions
Thread ID: 365353 Message ID: 365362 # Views: 54 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 25, 2012 11:45:25 AM         
   


I think transaction is needed even for a single table change/update especially if there are chances of multiple-rows updates and even more so if there are chances of multiple sqlexec()s before committing/flushing. However, one has to decide on whether it is best to use the automatic mode or manual mode, and whether to use SPT or cursor adapters / updatable views - Ref. SQLSETPROP() various settings

David
..
.




> > hi all,
> > i have developed some software as per client requirement but i did not use any transaction.
> > i want to use is there any need to use transaction in multiuser application or not?
> >
> > now i am using sql as database and before this i was using vfp database. is there need in sql too? please guide me.
> > thanks in advance.
> > Rupesh Kumar Sharma
> > Dhanisha Infotech
> > Jaipur, India
>
> If you updating more than one table you should use transaction specially in multiuser environment. Its Design pattern so its applicable on every database you used either vfp or sql.
>
>
>
>
> Anil
>
>
> Accounting Software
>
> Web Development
>
> Accounting, Inventory, Hotel Management, Restaurant Kot Billing, MLM, Excise Accounting and much much more!.
> My Blog

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