General information
Forum:
Microsoft SQL Server
thanks....For that info.
I'll try it out.
Here's what I want to do.
I have a function CSRLOCK()
The idea of it is that it performs operations identical to RLOCK() in vfp.
RLOCK() only NOT RLOCK() with parameters....
I need to Lock indivdual records (or maybe groups of records (in a grid))
and deterimine if they are in use. On Oracle and SQLServer.
It's not so hard. Because I have a Cursor with the primary key in
matching the pk on the sqlserver or oracle server.
ALthough I haven't done it yet. My idea is that when the edit button is pressed.
I issue the commands we are talking about where the PK is the one in the cursor.
SO really all I need is what you have given me.
Your warning scares me a bit.
Does this mean if I do the select as you described on specific PK.
That all other records previous to it will also be locked.
I only want to lock the 1 record.
I am very tired so I hope i am making sense....
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only