Hi, Hugo,
Thanks for the reply and for showing me the option to replace the macro.
I have alot of code written in this manner. Had I known that macros in SQL statement fool the compiler, I would have done otherwise.
Dawa
>>David,
>>
>>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.
>>
>>Dawa
>
>
>Not necessary Dawa, you can use from (myTable1) as Table1, (myTable2) as Table2 and then you can name the fields Table1.a, Table2.a etc.
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature