Lino Website

working on firebird connection

Wednesday, 7. September 2005 05:02.

Firebird doesn't want an SQL statement «SELECT COUNT(*), id, name_en FROM Languages;». It says «Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).»

Peter explains why: «If you combine in the select an aggregate function (count, sum, max) together with 'normal' colums (id, name, etc.), all the normal columns have to be in the group by clause.» (forums.devshed.com/archive/t-180673/Help-with-query-Invalid-expression-in-the-select-list)

Copyright 2001-2007 Luc Saffre.
http://lino.saffre-rumma.ee
Generated 2007-06-07 16:22:33