Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing a View's SQL Property
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00205981
Message ID:
00206204
Views:
19
Erik:

I thought about adding a bunch of view parameters to the existing view, but the users will be building the queries from a query form, so, what if all the parameters are not filled in? Won't it bomb?

I like the idea of building the view on the fly. I found an article in FP advisor that shows how to do so. To do this, I think I'm going to have to install my dbc's locally. Not quite sure of the implications of doing so. I always put them on the network.

Do you think it would be better to just run a query into a cursor, then make it updateable using CUSORSETPROP()? Can you duplicate the functionality of a View this way? Sounds like a better idea then screwing around with the DBC.

Thanx,
Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform