Hi

Why not .....

select mstwid as warehouseCode, mstiid as itemCode order by mstWid

or

select mstwid as warehouseCode, mstiid as itemCode order by 1

These should not interfere with your persisant fields. Hope I understand your question / problem correctly :)



Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: Mark Gordon
To: firebird-support@yahoogroups.com
Sent: Monday, December 20, 2004 2:14 PM
Subject: [firebird-support] order by column alias problem


I just hit a huge road block and I am not sure what to do.

This query works on all database except firebird:

select mstwid as warehouseCode, mstiid as itemCode order by warehouseCode

The error that it gives is Column unknown WAREHOUSECODE

I am using a persistence layer that uses this construct....
Other then, "use a different persistence layer", does anyone have any
advice?

Thanks
Mark


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]