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....