Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 2065 on a view or cursor? Should it even happen?
Message
De
26/03/2005 21:11:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error 2065 on a view or cursor? Should it even happen?
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00999316
Message ID:
00999316
Vues:
62
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform