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

Click here to load this message in the networking platform