Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 2065 on a view or cursor? Should it even happen?
Message
From
26/03/2005 21:11:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error 2065 on a view or cursor? Should it even happen?
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00999316
Message ID:
00999316
Views:
63
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
Next
Reply
Map
View

Click here to load this message in the networking platform