Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backend fails an update, can I handle this better
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Firebird
Application:
Desktop
Miscellaneous
Thread ID:
01376701
Message ID:
01376987
Views:
18
Why don't you validate data on front end to avoid the error?
Why do you refresh the form instead of handling the error?

>
>I have defined some constraints on the FireBird backend database. On violation the form looses all the data and goes into a blank state as the remote view is probably blanked. I am using CodeBook as the framework. The following is the message that I get for a Unique Key violation
>
>violation of PRIMARY or UNIQUE KEY constraint "UNQ_MLOOKUPS_CATEGORY" on table "MLOOKUPS"
>
>Can I handle this more gracefully?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform