Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00456273
Message ID:
00456299
Views:
24
>Hi George,
>
>You may generate the code for your remote views with GENDBC.PRG (I think some of view utilities on UT generate the full code for the selected view too.), and then update the code and re-run it when needed to recreate the view.

Nick (et al),

Believe me, I've thought about GENDBC.PRG. Unfortunately, running the code it generates, plus the modifications that would be required isn't as simple as simply modifying the view, making a change and saving it, since the problem is that the new or modified field changes aren't included unless the one of the views is modified once. What I was really hoping for was something like a command or series of commands that could do this. Something like, UPDATE VIEW < viewname > would be terrific.

I've thought about writing code that would connect to the source, getting the field names and types, parameters, etc., drop the existing view and re-generate it, but that's more work than I want to tackle at the moment.

I've got a crazy idea that I'm going to try out, and if it works I'll post back.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform