Record lock issue

I get the following error when I run the seek command
Record is in use by another user
It is true that the record I am doing a seek on is locked but I am merely
trying to move the record pointer to it to see if it is locked. I am not
writing to that record with a seek so why do I get this? I have this same
code in other areas but only in this one spot does it happen.

--
Altman
VFP7 SP1

"No matter how foolproof you make a system, 'fools' can be remarkably
ingenious."

mspratt
Thu Nov 06 10:04:43 CST 2003

Hi Altman,

Is something editable bound to the table? Textbox, Grid, etc.

Regards,

Mike

On Wed, 5 Nov 2003 16:30:14 -0600, "Altman" <NotGiven@SickOfSpam.com>
wrote:

>I get the following error when I run the seek command
>Record is in use by another user
>It is true that the record I am doing a seek on is locked but I am merely
>trying to move the record pointer to it to see if it is locked. I am not
>writing to that record with a seek so why do I get this? I have this same
>code in other areas but only in this one spot does it happen.

Altman
Thu Nov 06 10:59:29 CST 2003

OK figured it out, apparently there was an update sql statement happening
before I try to RLOCK() and it didn't try to update that record until I did
the seek, so the error happened on the seek line but was not caused by the
seek line.
"Altman" <NotGiven@SickOfSpam.com> wrote in message
news:u$YNxv%23oDHA.1708@TK2MSFTNGP12.phx.gbl...
> I get the following error when I run the seek command
> Record is in use by another user
> It is true that the record I am doing a seek on is locked but I am merely
> trying to move the record pointer to it to see if it is locked. I am not
> writing to that record with a seek so why do I get this? I have this same
> code in other areas but only in this one spot does it happen.
>
> --
> Altman
> VFP7 SP1
>
> "No matter how foolproof you make a system, 'fools' can be remarkably
> ingenious."
>
>