Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trapping unique errors on index
Message
From
30/03/1997 00:20:04
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
 
 
To
29/03/1997 14:10:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00026157
Message ID:
00026185
Views:
30
When you are adding in the file, before that check existense of
your primary field, by using a locate or a seek command.

if not found then add a new code other wise issue a tablerev, if
you have already issued a append blank.

if key field is numeric, you can use this line

sele max(keyfield)+1 from yourdbf into array yourarray



>Hi
>
>I have a dbc with 5 tables
>they are indexed candidate.
>
>In my form.grid if I try to enter a equal number
>and it exsist I get an error that is ok, but how
>do I trapp this error, and run a tablerevert.
>Im using 5 optimistic buffering in the DE.
>In my exe you get 3 options on this error
>and the only who works is cancel and there
>goes my app.
>
>Best regard
>
>Per Simmersholm
Previous
Reply
Map
View

Click here to load this message in the networking platform