Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select-sql on a modified view doesn't show changes!?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00312560
Message ID:
00316295
Views:
21
>Gerard,
>
>Yeah they behave differently but they are commands in two different languages really, SELECT is SQL and COPY is xBase and SQL and xBase are different.

Yes,they are different,but both can operate on the same data structures.
If SQL was not meant to work on buffered views, I think VFP should probably throw up an error and stop....When would anybody ever want to run a SQL statement on a buffered view, rather than on the 'actual' database behind the view, in that there's going to be no difference.

Regards,

Gerard
Previous
Reply
Map
View

Click here to load this message in the networking platform