Hi,
I am about to write a data access layer in my framework utilising sprocs for all CRUD activity. With Fox remote views, conflict resolution is taken care of by Fox.
With the application in question, many of the sprocs already exist and many of the tables do not have a time stamp column. The sprocs are used by numerous client access methodologies and therefore, the sproc "signature" has to remain "standard" and not Fox specific.
Does anyone know how you would go about detecting and reporting conflicts when using sprocs in the way I have outlined above? By this, I mean that whilst I could, say, detect columns on the client side that have changed by checking the buffered changes against the original query values and in some way (by parameter?) notify the sproc to check for specific changes, other clients using the same sproc(s) may not have such capabilities and therefore, the sprocs must have a generic and somewhat standard signature.
Thanks,
-=Gary