Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating to table
Message
 
 
À
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:
01094972
Vues:
11
See SELECT - SQL WITH (BUFFERING = lExpr) clause.

>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.
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform