Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate
Message
 
To
01/11/2006 07:33:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Miscellaneous
Thread ID:
01166090
Message ID:
01166097
Views:
11
>I just want to make sure that my thinking is correct.
>
>I have the following code.
>
>Do While seek(vi_key)
> Replace key with l_key
> tableupdate()
>enddo
>
>My question is: If I move the tableupdate out of the loop, will the seek see the updated records with their new values? I do not want it to, so that is why I am thinking of moving the update out of the loop.
>
>THanks in advance.
>Christine

No matter where is TABLEUPDATE() placed this loop will work with new values. I prefer TableUpdate to be fired only once when I finish my updates.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform