Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select-sql on a modified view doesn't show changes!?
Message
From
04/01/2000 13:48:36
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00312560
Message ID:
00312584
Views:
28
>>>I made a view that I modify using a grid on a form.
>>>Then, I want to issue a select based on this modified view.
>>>When I do, it seems to get the original value instead of the modified ones.
>>>Any suggestion ?
>>
>>Do a TABLEUPDATE() against the view before issuing the SELECT.
>If I do a tableupdate() of the view, will it write back to the physical table of my view? (I don't want to do this)

You can copy the View's data out to another table/cursor and then use that as your source table for your SELECT.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform