MySQL ->Sybase query problem

Classic Servoy
1

First of all: I converted to Sybase a solution based on MySQL in less than 5 minutes: great work, dev team :slight_smile:

The only problem I noticed is related to SQL queries:
Using this query

SELECT
	 p.pianiid, p.data,a.nome, a.cognome, SUM(li.prezuni), p.saldo, p.delta
	 from anagrafica a, rigpiani li, piani p
	 where p.yearnr = 2003
	 and a.anagid = li.anagid 
	 and p.pianiid = li.pianiid 
	 and p.accettato = 'sM-l' 
	 group by p.pianiid order by 1 asc

(btw: anagrafica = patients; piani = treatments; rigpiani = lineitems)
I don’t have any problem in MySQL, but with SyBase I get this error:

com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -149: Function or column reference to 'data' must also appear in a GROUP BY ASA Error -149: Function or column reference to 'data' must also appear in a GROUP BY
[code]
I get the same error launching ther query from Interactive SQL Utility: is it a syntax problem?
2

make sure your selected columns also appear in the group by :
except for SUM(li.prezuni)

SELECT 
p.pianiid, p.data,a.nome, a.cognome, SUM(li.prezuni), p.saldo, p.delta 
    from anagrafica a, rigpiani li, piani p 
    where p.yearnr = 2003 
    and a.anagid = li.anagid 
    and p.pianiid = li.pianiid 
    and p.accettato = 'sM-l' 
    group by 
p.pianiid, p.data,a.nome, a.cognome, p.saldo, p.delta 
order by 1 asc