Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate()
Message
 
À
29/10/2002 10:34:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00716150
Message ID:
00716495
Vues:
18
>>>>>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,

Great! You may pay a small penalty with updates and inserts, but it's well worth it. The previously mentioned book is very emphatic on the point that the controller mustn't report that the "bits have hit the disk"< s >, until they actually do.
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform