Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement