Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bhushan Sahni
  Where is Bhushan Sahni?
 Jabalpur/Mumbai
 India
 Bhushan Sahni
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Transactions on VFP Table
Thread ID: 288978 Message ID: 289041 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: .NET
Date: Tuesday, December 28, 2010 5:12:27 AM         
   


> > Dear All,
> >
> > I am seeking for some experiences on implementing .NET Transaction (Front End) on VFP Tables.
> >
> > The scenario is that I am inserting data from .NET into 2 VFP tables (Part of DBC). On these two tables, I am planning to write Trigger to insert into corresponding another two free tables.
> >
> > The tables in the DBC will be intermediate tables and which in turn will populate the actual tables with some manipulation and data fetching.
> >
> > For this whole cycle I wish to implement transactions through .NET. Even other suggestions are welcome.
> >
> > Please help me out, I don't want to scrap my development so I would be happy to have expert feedback.
> >
> > Hope my explanation is clear enough.
> >
> > Thanks in advance.
> >
> > Regards
> > Bhushan Sahni
> > Eitzen Group (IT)
> > bsh@eitzen-group.com
> > Visual Foxpro a dream house for developers
>
> 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

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