George,
Write behind caching was enabled. We disabled it an haven't experienced an update problems since.
Thanks,
Joe
>>>>>I have a Client/Server application with remote views against tables in a MS SQL 2000 database. Occasionally, even though TableUpdate() returns .T., the SQL data is not updated. I've confirmed that the correct field value is present before the update is issued.
>>>
>>>George,
>>>
>>>Yes, "Send Updates" is checked. Remember it only happens (fails to update)occassionally. I'm beginning to wonder is it's an issue with the machine's local cache, or the ODBC driver, or a SQL 2000 issue.
>>>
>>Joe,
>>
>>One other thing to consider. SQL Server (all versions) depend on there being no write behind caching. IOW, if the server is set-up to allow write behind, that may be the source if your problem. Inside SQL Server 7.0 documents this. What I'm guessing may be occurring is that between the TABLEUPDATE() and REQUERY() the updates haven't been committed to the disk.
>
>George,
>
>write behind caching was enabled. We are disabling. Thanks.
>
>Joe
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