Hi,
When using remote views, you can set the WhereType value to one of the following --
DB_KEY
DB_KEYANDUPDATABLE
DB_KEYANDMODIFIED (the default)
DB_KEYANDTIMESTAMP
This is fine and very convenient when using views. However, I have a requirement to provide an all round retrieve/update solution to SQL server using stored procedures only. For this, I am creating a data access subclass in my framework for cursor types in Fox created solely by sprocs.
Apart from writing application based conflict resolution code into the sprocs which I don't really want to do), how can the functionality provided by VFP with remote views be "utilised" or tapped into when using sprocs? Does Fox find this functionality from within the ODBC driver? If so, how can it be accessed?
So, in a nut-shell, I would like to be able to send an update back to the SQL server using a sproc and have ODBC tell me when there has been some form of conflict on the server.
Any advice or information on this would be greatly appreciated.
Thanks.
-=Gary