Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rick C. Hodgin
  Where is Rick C. Hodgin?
 Indianapolis
 Indiana - United States
 Rick C. Hodgin
 To: rupesh sharma
  Where is rupesh sharma?
 jaipur
 India
 rupesh sharma
 Tags
Subject: RE: transactions
Thread ID: 365353 Message ID: 365365 # Views: 49 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 25, 2012 12:07:20 PM         
   


> 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?


There is no explicit need to use transactions. It can make it easier to undo when user cancels. Is definitely not needed though.

Edit: I have been designing software systems for various industries since the late 1980s and I have never had an explicit need for transactions in the literal BEGIN TRANSACTION sense. I have been able to achieve commensurate functionality (with many extensions) by implementing classes to handle "transactions" in that regard. Transactions make it easier. But it is definitely not an overt need.


> now i am using sql as database and before this i was using vfp database. is there need in sql too? please guide me.


Sql Server can offer improvements in multi-user environments, or when data needs to be shared by desktop + web apps, for example. Again, is not required. Edit: Completely robust systems can be written which use ONLY the VFP multi-user data engine.

Is usually the requirements of the application which determines the needs.


> thanks in advance.
> Rupesh Kumar Sharma
> Dhanisha Infotech
> Jaipur, India


Best regards,
Rick C. Hodgin

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