Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create a local view with whatever SQL statement?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00142471
Message ID:
00142483
Vues:
33
>Hi,
> I don't really know whether there is a way of doing this, I want to create a view without using the View Wizard with an SQL statement that I type. From the view wizard, I can see the equivalent SQL statement, but I couldn't edit it. Is there any way of doing this?
>And this view may have parameters and it will be included in DE of a form. I basically want to avoid writing SQL queries(the cursors) in the code and want to keep them in a view.

What others suggest is fine if simple, but if you have some non-default view properties such as setting update fields, a good way to do it is to use the view designer to approximate your view to the dbc, then run GENDBC, cut out all the view code, paste it to where you want it, and then edit the view settings as needed...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform