Hi,
i post this question on support group two weeks ago without answer
maybe FB developers can answer for this question
.....
i need to know what is difference in meaning of collate between this three
queries
FIRST and SECOND is accepted by server
but THIRD return error "Invalid expression in the select list (not contained in
either an aggregate function or the GROUP BY clause)"
/* FIRST */
select w.wplata_nr_wyciagu collate PXW_PLK
FROM
WPLATA w
group by w.wplata_nr_wyciagu
order by w.wplata_nr_wyciagu
/* SECOND */
select w.wplata_nr_wyciagu collate PXW_PLK
FROM
WPLATA w
group by w.wplata_nr_wyciagu collate PXW_PLK
order by w.wplata_nr_wyciagu collate PXW_PLK
/* THIRD */
select w.wplata_nr_wyciagu
FROM
WPLATA w
group by w.wplata_nr_wyciagu collate PXW_PLK
order by w.wplata_nr_wyciagu collate PXW_PLK
regards,
Karol Bieniaszewski
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
