>>
>>It was consistent. I mean without changing anything in the SQL clause that sometimes it generates a SQL with the field name and sometimes with EXP_1.
>
>OK, I just tried this:
>
>"select mailingAddress AS mailingaddress from voucher"
>
>VFP6 did not give an error, so you should be able to do "select desc from...as desc" and see if that forces the correct field-name. That might help.
Yes, the AS is what we used since the first day we encountered this.