Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating to table
Message
From
09/02/2006 08:41:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Updating to table
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01094967
Message ID:
01094967
Views:
54
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...
Next
Reply
Map
View

Click here to load this message in the networking platform