Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00456273
Message ID:
00456299
Vues:
25
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform