Mysql ODBC driver fails to execute aggrigate functions?

[prashant.nirgun]

Description:
I am using powerbuilder 5.0 and Mysql 5.0.27-commnunity-nt
use following statment
Error Messagee :
SQLSTATE = S1T00
[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]FUNCTION veg.sum does not
exist

Code :

int it

select sum(item_id) into :It from item ;

if SQLCA.SQLCode = -1 then MessageBox("SQL
error",SQLCA.SQLErrText,Information!)
messagebox("count",String(it))

How to repeat:
I tried this command in powerbuilder database administrator option without using
into plane statement it works i tried max, min and sum all aggricated funciton
fail when i try to stored result in variable.

[ajreal]

Not sure about the MySQL environment in windows, but i believe the select statement is wrong.

It should be :

select sum(item_id) into @It from item ;
select @it;