>
>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