Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing the SQL property of a View on the fly
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00283275
Message ID:
00283856
Views:
16
>Wayne:
>
>You don't send any parameters to the View. You build a SQL string from a query form or something similiar, then pass it to a prg that drops the view from the dbc (local) then recreates the view with a the new WHERE clause. In the DE you must close and reopen the tables in order for it to take effect.
>
>It is especially useful in C\S application. The user has complete control over the data brought down from the server.
>
>Charlie

It really sounds like you would be better off using pass through... then you could create your select statement on the fly.


Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform