Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to modify a view on the fly
Message
From
23/05/2008 02:38:50
 
 
To
22/05/2008 07:28:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01312116
Message ID:
01319166
Views:
15
>
>A faster way may be to copy the dbc and add records for the new view fields. Wonder what is the format of DBC.property for view fields? In one case for an added field defined as "SPACE(60) AS cMostrar" in the view I found the following:
>
>
>StrConv(Property,15)
>08000000010026000800000001002D0010000000010023636D6F7374726172000D00000001004D432836302900
>
>Which prints as:
>    &     -     #cmostrar
>    MC(60)
>
>
>Alex

Interesting - you'd probably also need to edit the objecttype="View" record, right?

I'm curious: Why do you want to add (and remove?) fields at runtime?

FWIW, in scenarios where the "native" parameter options of views seem to be too limited, I prefer SqlPassThrough classes or CursorAdapters, too.
Often those "advanced" requirements were dynamically adding and removing Where clauses though, I believe I have never needed a "parameterized field list" yet.


Regards
-Stefan
Previous
Reply
Map
View

Click here to load this message in the networking platform