Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Intermittent view update failures?
Message
De
01/07/2002 12:21:34
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Intermittent view update failures?
Divers
Thread ID:
00673944
Message ID:
00673944
Vues:
54
I am using a cursor created from a view as:
= AFIELDS(myarray,"styles")
CREATE CURSOR temporder FROM ARRAY myarray
and using this cursor to gather purchase order info. When the user does a save, I transfer the temporary data from the cursor to the view using:
    REPLACE styles.onorder WITH styles.onorder + temporder.onorder, ;
      styles.plabel WITH .T., ;
      styles.howmany WITH IIF(styles.categoryid = "8",1,temporder.onorder)
inside of a SCAN loop. The problem users are seeing is that the value of temporder.onorder is not reliably getting written into styles.howmany, yet never fails with the REPLACE with styles.onorder. It might be 1 or 2 short out of 700-800 records, 5 failures in 200 records, etc. Very intermittent. The data is stored on a NT4 SP6a Server. Clients are Win95/98 and NT4 WS. All may show this behavior. No TABLEUPDATE() failures, just incorrect data being stored. VFP6 SP5 BTW. All NT4 caching is turned off, I have sprinkled a few FLUSHes to no avail.

Any ideas, anyone?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform