Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question about Tablevalidate Setting
Message
De
09/02/2006 11:14:33
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
 
 
À
09/02/2006 09:17:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01094960
Message ID:
01095068
Vues:
18
Jim,
You are correct about the error occuring inside a transaction. In fact, it occured on the line 'End Transaction' which indicates that begin trans and end trans are doing some internal checking of file lengths versus header lengths and that in this checking the status of tablevalidate must be ignored. How would you trap for this error? Would something like this work -

try
end transaction
catch to myerr when myerr.errorNo=2065
* is 2065 the only error that could occur on the end transaction line
rollback
alert the user to the problem
try to fix the problem as you outlined in your reply
endtry

The error message indicates the table that the error occured on. Does adding and then deleting a record fix the problem?

Calvin
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform