>Good morning,
>
>I need to create a routine of selecting (using SQL Select) only certain fields from a table/cursor. The fields that are to be selected should not be hard coded into the SQL Select. For example, if I could create an array where the fields would be stored, as e.g.:
>
>

>local array aFlds[3]
>aFlds[1]="myfld1"
>aFlds[2]="myfld2"
>aFlds[3]="myfld3"
>

>
>If I could then use this array in the SQL select to select only these fields. Is something like this possible?
>
>Any other suggestions?

Macro substitution was already suggested; let me add that you can decide whether it is more practical to ampersand the entire SELECT command, or individual clauses. For me, the field list is usually fixed, but the sort order is sometimes not, so I macro-substitute an individual clause, something like this:

if ThisForm.OpgSortBy = 1 && By client Code
  lcSortBy = "ClientCode"
else && By name
  lcSortBy = "LastName, FirstName"
endif
select ...;
  from ClientMain;
  order by &lcSortBy;
  into cursor Tmp;
  nofilter
...

But you might also create an entire SQL - SELECT command and macro-substitute it all at once:

lcSortBy = ... (as above)
lcWhere = "where IsActive"
lcCommand =;
  "select * from ClientMain ";
  + "from ClientMain ";
  + "order by " + lcSortBy;
  + lcWhere;
  + " into cursor Tmp nofilter"

Of course, ycould also add the new-lines, so the command is easier to read in the debugger.

Note that in the "order by" clause, the "order by" is outside the variable, but in the "where" clause, the "where" is part of the variable. This makes it easier to conditionally NOT use a WHERE clause. Otherwise, you would have to put a clause like "where .T.".