Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Camil Ghircoias
  Where is Camil Ghircoias?
 Camil Ghircoias
 To: Eric Puah
  Where is Eric Puah?
 Eric Puah
Subject: RE: TableUpdate question
Thread ID: 228467 Message ID: 228475 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, May 19, 2009 9:34:59 AM         

> I have write a problem with Begin Trans and end tran.
> in between i have do update for few table. How should i issues the tableupdate, it should be inside begin trans or outside? will =tableupdate(.T.) will it update all the table i have write between begin trans? Please advise. Thank you

Begin transaction will save all the data changes made between begin and end transaction.
Tableupdate makes a change to the data on the base table, as it saves it to the disk.
Begin transaction locks all the changes tableupdate makes on base tables, and unlocks them on end transaction command. On rollback command it restores data on base tables to the previsious state before tableupdate and of course unlocks them.
The data on buffered cursor remains changed, so you have to put tablerevert after rollback command.

Camil Ghircoias


TableUpdate question Posted by Eric Puah @ 5/19/2009 8:54:34 AM
RE: TableUpdate question Posted by M. Akram Bhatti @ 5/19/2009 9:03:11 AM
RE: TableUpdate question Posted by Camil Ghircoias @ 5/19/2009 9:34:59 AM