Hi Jim

>The error message is: "Table "C:\DOCUME~1\jim\LOCALS~1\Temp\55S808TH.TMP" has a file length / record count inconsistency that will not allow this transaction to be committed. Please open the table exclusively and PACK it.".
>The error is occurring on the line:

DELETE FROM mydata!MyTable1 WHERE Tbl1_pk=OLDVAL('Tbl1_pk','MyTable1View')

Tbl1_PK is an integer field.
>The command executes properly countless times. As indicated by the error number, it is within a TRANSACTION.
>I assume that the .TMP file is the view, but that *is* just an assumption.
>The DBC and the table are on a Win2000 Server system and the view is in another DBC on the same server.
>Though it means nothing in the context of this error, SET TABLEVALIDATE is 2.
>
>Any ideas as to what might be causing this or a workaround to prevent?
>
>Thanks

Unless there is a SET RELATION won't your OLDVAL() be returning the same value for each deleted record? If so does this help and/or improve performance?

LOCAL luTbl1_pk
luTbl1_pk = OLDVAL('Tbl1_pk','MyTable1View')
DELETE FROM mydata!MyTable1 WHERE tbl1_pk = m.luTbl1_pk