Hello Arto, thanks for the reply.
>
>cFields = STRTRAN(STRTRAN(FILETOSTR("MyFields.txt"),CHR(13),""),CHR(10),"")
>SELECT &cFields FROM MyTable WHERE ?myfilter
>
>
>Now you can have different field orders as far you have same fields. You just have to update MyFields.txt always when Fields are inserted or deleted or name changed. Also both have same MyFields.txt
Worth thinking about, but I would modify it so that the field listing came automatically from the table structure (eg. using AFIELDS()), rather than maintain the file manually.
Also, the above method would not be suitable for updatable views without a lot of DBSETPROP() commands to ensure the fields are updatable (unless you have any bright ideas in this area!)
Regards,
Alan