Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 Tags
Subject: RE: how to lock a table,row in SQL server from VFP
Thread ID: 104068 Message ID: 104168 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, August 12, 2006 1:38:26 PM         
   


> Am I right? Please give more comments.

The issue is the performance implication. I cannot tell you what that will be in your application, nor can I tell you what your business rules and requirements are. You asked me when I use it and I have told you.

> There are 2 problems with the code above.
> 1) The TABLEUPDATE(.T.,.T.)issued after "IF lnResp=6 && YES clicked" is ok for a remote view. But what is the equivalent code for SPT? Or there is no way to do a second attempt to overwrite data changes after a update conflict occurs in SPT?


There is no "equivalent code". TableUpdate is a local FoxPro function and has nothing to do with SPT.


> 2) There is still chance for lock_timeout error for TABLEUPDATE(.T.,.T.), so I have to use AERROR() to detect it again after TABLEUPDATE(.T.,.T.) and again? Is it a choice up to me? To make it easy, I prefer to use SQLRollback immedately after the first TABLEUPDATE(.T.,.F.) or SQLExec() returns .F. or <1 respectively. It is a lazy way, but good for a programmer, yes?

If that meets your application's needs and rules then it is fine. I cannot tell you what your rules and requirements are and so I cannot offer an opinion on whether this is good or not.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

ENTIRE THREAD

how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 3:20:15 AM
RE: how to lock a table,row in SQL server from VFP Posted by Ken Murphy @ 8/11/2006 4:47:44 AM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 5:07:11 AM
RE: how to lock a table,row in SQL server from VFP Posted by Andy Kramek @ 8/11/2006 11:39:06 AM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 4:31:02 PM
RE: how to lock a table,row in SQL server from VFP Posted by Andy Kramek @ 8/11/2006 7:42:52 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/12/2006 5:21:05 AM
RE: how to lock a table,row in SQL server from VFP Posted by Andy Kramek @ 8/12/2006 1:38:26 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/12/2006 5:39:49 PM
RE: how to lock a table,row in SQL server from VFP Posted by Andy Kramek @ 8/12/2006 9:55:28 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/13/2006 5:14:59 AM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 4:47:07 PM
RE: how to lock a table,row in SQL server from VFP Posted by Martin Sellwood @ 8/11/2006 11:55:11 AM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/11/2006 2:22:22 PM
RE: how to lock a table,row in SQL server from VFP Posted by tushar @ 8/11/2006 2:37:23 PM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/11/2006 3:55:07 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 5:15:22 PM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/11/2006 5:52:49 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 6:15:35 PM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/11/2006 8:09:02 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/12/2006 5:31:24 AM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/12/2006 9:28:20 AM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/12/2006 5:44:43 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 4:44:27 PM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/11/2006 4:52:50 PM
RE: how to lock a table,row in SQL server from VFP Posted by Martin Sellwood @ 8/11/2006 5:04:19 PM
RE: how to lock a table,row in SQL server from VFP Posted by Dexter Carlit @ 8/11/2006 5:18:03 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 5:47:53 PM
RE: how to lock a table,row in SQL server from VFP Posted by Nilson Rishi @ 8/11/2006 5:41:32 PM