What exactly is the problem though? It isn’t sorting or something else?



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of olaf.kluge@...
Sent: Sunday, December 21, 2008 12:05 PM
To: firebird-support@yahoogroups.com
Cc: olaf.kluge@...
Subject: [firebird-support] Problem group by in front-end (odbc)



Hello,

I've a problem. In Firebird 1.5 the follow sql-statement works fine:

SELECT TPROJEKTE.KOMMISIONSNR
FROM TPROJEKTE
WHERE (((TPROJEKTE.KUNDE)=[forms]![FAuftragNeu].[skunde]))
GROUP BY TPROJEKTE.KOMMISIONSNR
ORDER BY TPROJEKTE.KOMMISIONSNR DESC;

Without the order by statement the data sorted by tprojekte.kommisionsnr ascending. But I need the data sorted descending.

The Database-Server is now Firebird 2.1. The front-end is microsoft access over odbc (firebird-odbc-driver)

Can I change the sql-statement that it works again?

thank you very much.

Regards

Olaf





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