Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error handling - duplicate record
Message
De
06/08/2005 06:05:22
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
03/08/2005 06:40:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01038074
Message ID:
01039074
Vues:
21
Hi Irene

You should avoid hard coding paths and drive letters.

>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’?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform