>I am updating 1050 rcords in a table buffered view. My code looks like this:
>
>
>REPLACE ALL iForeign_key WITH 100
>BEGIN TRANSACTION
>IF !TABLEUPDATE(.T.,.F.)
> ROLLBACK
> =TABLEREVERT(.T.)
>ELSE
> END TRANSACTION
>ENDIF
>
>
>The TABLEUPDATE() updates the first 500 records and then stops, displaying a "waiting for lock" message. (Reprocess is set to 15 seconds.) When AERROR is checked the error message is #109, "Record is in use by another user." There is no other user. The data is being accessed by only one user (myself), but the table is locked. The interesting thing is ISFLOCK() and ISRLOCK() both show .F. Does anybody have ideas, here? I'm about to lose my hair and my partner already has.
Are you trying to do this on a Novell NOS? You'll have to up the lock count somewhere in the NOS, the default is 500, I think.