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