Any idea why the tableupdate in the following code would fail. Note that this is a simplified version of my code. In my application I am actually updating five tables.
SET MILTILOCKS ON
SET EXCLUSIVE OFF
SET DELETED ON
USE mytable IN 0 shared
=CURSORSETPROP("buffer", 5, "mytable")
DELETE FROM mytable WHERE RECNO() <= 500
BEGIN TRANSACTION
IF !TABLEUPDATE(.T., .T., "mytable")
ROLLBACK
= TABLEREVERT(.T., "mytable")
ELSE
END TRANSACTION
ENDIF
The above test works when I only delete 499 records but when I try 500 it fails. Each record in mytable is 1426 bytes. I also have the same problem if referential integrity deletes the 500 records (cascading delete).
Thanks,
Shane
Shane Murdoch