Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating to table
Message
De
09/02/2006 08:46:08
 
 
À
09/02/2006 08:41:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01094967
Message ID:
01094968
Vues:
14
>Three values get updated to a table and then straight after that I select from that table those values and additional once. Code used to update:
>
> SELECT bkplpayh
> nSeek = lnAccNo
> SEEK lnAccNo ORDER ph_accno
> replace bkplpayh.ph_netproc with lnNetProc, ;
> bkplpayh.ph_ivat with lnTotIVat, ;
> bkplpayh.ph_totdeduc with lnTotDeduc
>
>If I debug, the variables contains the correct values, but the select following the above code returns 0.00 for all three. If I look in the table via browse the data was updated. It is almost as if the replace not yet completed when the select occured.
>
>Help please...

Is the table buffered? Do you need to issue Tableupdate() after?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform