>Is one of these techniques better than the other? Is there a disadvantage to using the asterisk wildcard? Both seem to work okay but want to be sure I'm not setting a disadvantageous precedent.
>
>Example #1:
>
> select MyTable
> for i = 1 to fCount()
> lcFieldList = lcFieldList + ’MyTable.’ + Field(i) + ’,’
> endfor
>
> select &lcFieldList from MyTable into cursor MyCursor
>
>
>Example #2:
>
> select MyTable.* from MyTable into cursor MyCursor
>
>
>
>Thank for any opinions.
Asterisk is straightforward way. If you really want to select flexible set of particular fields then you can generate macros string.
Edward Pikman
Independent Consultant