Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to modify a view on the fly
Message
From
22/04/2008 03:10:25
 
 
To
21/04/2008 13:00:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01312116
Message ID:
01312312
Views:
20
>Hi,
>
>I have a remote view defined in the DBC and would like to add fields to it at run time but there is a catch-22. Remote views have to be buffered either row or table, so they cannot be ALTERed. So the question becomes, how can I define a view on the fly, starting from the one in the DBC but adding the required fields, yet not pollute the DBC with superfluous views?
>
Hi,

Alternatively you can create a local "(Remote)ViewsOnly.DBC" on the fly at runtime, say in GetEnv('temp'). See also Home()+'\tools\gendbc\gendbc.prg'.


hth
-Stefan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform