Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error handling - duplicate record
Message
De
03/08/2005 06:40:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Error handling - duplicate record
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01038074
Message ID:
01038074
Vues:
62
In the click event of the ‘SAVE’ button I have the following code to trap errors.
-----
ON ERROR DO "w:\Talman develpment\bkbplus\errhand" with ERROR(), MESSAGE()
select bkplcont
tableupdate(.T.,.F.)
on error
------
For some reason the program only catches the error when you exist the program. Then giving the foxpro error 'Uniqueness of index CN_CONTNUM violated'.


In the load event of the form I 'use' the table with row buffering.

---------
SET MULTILOCKS ON

USE bkplcont IN 0 SHARED ORDER CN_PORG
lSuccess = CURSORSETPROP("buffering",3,"bkplcont")
----------

What must I do so that the duplicate error will be trapped when trying to ‘tableupdate’?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform