Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 To: Eric Puah
  Where is Eric Puah?
 
 Malaysia
 Eric Puah
 Tags
Subject: RE: TableUpdate question
Thread ID: 228467 Message ID: 228469 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, May 19, 2009 9:03:11 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
  llOk = TABLEUPDATE(.t., .t., "yourtable")
  IF llOk
    llOk = llOk and TABLEUPDATE(.t., .t., "othertable")
  ENDIF

IF llOk
  END TRANSACTION
ELSE
  ROLLBACK
  AERROR(laError)
  MESSAGEBOX(laError[1, 1])
ENDIF


Regards,
Akram

ENTIRE THREAD

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