Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Dexter Carlit
  Where is Dexter Carlit?
 Cabanatuan
 Philippines
 Dexter Carlit
 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: 104160 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, August 12, 2006 9:28:20 AM         
   


> Zed,
>
> > SQLEXEC( gnConnHandle,"EXEC sp_who2","Records_Connection_Status")
> >
> > * Get the "SPID" from this cursor "Records_Connection_Status" and try to put that value on the parameter below "Param1"
>
> You mean get the SPID for another user who is locking the record within his transaction? Yes
>
> > SQLEXEC( gnConnHandle, "EXEC KILL" + " " + param1)
> So the another user who is locking the record within his transaction wil lose connection with SQL Server after we KILL his SPID? Correct, but be advised that this is only an alternative way if you want to end/kill a process without going inside the SQL Server.
>
> Regards,
> Nilson


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