General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Vlad,
>>Quite strange things.
No kidding!
>>As about the updatable ID, you require to query it properly. ID used to find the record on SQl Serevr when updating data, so when it is incorrect, you will not be able to update record, or will update incorrect record because incorrect ID.
<<
When I requery the view, I get the VFP Update Conflict error message. Once again, the ID number field contains the value of the ID of another table!
>> In addition, when you add new records, ID require to be corrcetly generated or should be downloaded from server. For example, you insert record, update, SQL Server generates a new value for ID. Than, next time you try to update, ID field is emty on the local computer, so you cannot update or delete that record any more, because you do not know the ID. In such case you can requery the view, or get th last ID number from the SQl Server. This is a long complex story and you can read about this here at UT in many thred or somewhere else.
<<
Hmmm... I am going to study what you said. I am not sure I understand it The ID field in the Remote View is an integer identity field I created in SQL Server Enterprise Manager. So SQL-Server is doing the updates to it.
Thanks,
-pw
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only