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
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