Hi guys,
We are starting to use Data Abstract in our projects and we are trying to find out how to manage certain exceptions like duplicate key values on the client side.
The way it is working right now, the client enters a duplicate key value on some data edition and then it is until the server attempts to insert the row that a duplicate key violation comes back from the database and it is send to the client. There an exception appears which is managed by the reconcile dialog or an exception error which is way too technical for our customers.
On DataSnap there is a OnReconcileError per each provider that gives the error message, sometimes we simply parse the exception and translate it into a more human message to send the customer on the client side. What is the best approach on Data Abstract to manage this?
Ideally keys and unique indexes as set on the memdatatable should be send some exception if entered on the client side even before hitting the server side, but it doesnt seem to be the case.
In summary what is the best approach using DataAbstract to deal wit these kind of validations?