Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Bhushan Sahni
  Where is Bhushan Sahni?
 Jabalpur/Mumbai
 India
 Bhushan Sahni
 Tags
Subject: RE: Transactions on VFP Table
Thread ID: 288978 Message ID: 289300 # Views: 32 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: .NET
Date: Thursday, December 30, 2010 1:34:43 PM         
   


> >
> > The Help topic Supported Visual FoxPro Commands and Functions in OLE DB Provider
> > at http://msdn.microsoft.com/en-US/library/80x51c04%28v=VS.80%29.aspx
> > shows that a BEGIN/END TRANSACTION /ROLLBACK block is a supported command in VFPOLEDB.
> >
> > -Anders
>
> Dear Anders,
>
> Thanks for the link, can you pls comment me on the methodology I am planning.
>
> I am looking for few comments on the way I am planning to accomplish my task.
>
> Regards
> Bhushan Sahni
> Eitzen Group (IT)
> bsh@eitzen-group.com
> Visual Foxpro a dream house for developers

As BEGIN TRANS - END TRANS/ROLLBACK is a program block, that also typically involves an IF - ENDIF you'll use it in a stored procedure with suitable parameters in the VFP database.

-Anders

ENTIRE THREAD

Transactions on VFP Table Posted by Bhushan Sahni @ 12/27/2010 1:55:05 PM
RE: Transactions on VFP Table Posted by Anders Altberg @ 12/27/2010 2:27:50 PM
RE: Transactions on VFP Table Posted by Bhushan Sahni @ 12/28/2010 5:12:27 AM
RE: Transactions on VFP Table Posted by Anders Altberg @ 12/30/2010 1:34:43 PM