Hi Jason

I found another problem with RecordCount for a statement like this:

SELECT DISTINCT Fld1, Fld2 as Fld3 FROM Table1

This is transformed for the RecordCount statement as

SELECT COUNT(DISTINCT Fld1 || '.zZz.' || Fld2 as Fld3) FROM Table1

which is not working.

Cheers
Daniel