Dawa,
But you see that the & macros prevent the compiler from detecting the error at prg save time. It will not detect the error until that code is compiled on the fly at runtime. Which means that you should keep a good regression test plan in place.
>I could get rid of the macro if I am only including fields from one cursor/table which is in this case, so your solution is correct. But when I select them from multiple tables or cursors, which I have to in most cases, then I need to include the alias names lest there should be same field names with different values.