pls help. PowerBuiler 6.0 call sum() to access MYODBC/MYSQL fail.

My developing environment:
1. MySQL Server 5.0
2. MyODBC 3.51 Driver
3. PowerBuilder 6.0

When i run the following statement in PowerBuilder program:
SELECT sum(serialno) into :iii_int FROM Applicant;
the system return error:
sqlca.sqlcode=-1
sqlca.sqldbcode=1305:SQLSTATE=S1T00
sqlca.sqlerrtext=FUNCTION pams2006.sum does not exist.

(pams2006 is database name in MYSQL.)

In fact, functions such as max(), min(), sum(), return the same error message.
But when insert , update , edit in powerbuilder datawindows, the system is normal.

pls help me.

Thanks.


Rick Zhang
Beijing, China
Regards
2005-05-16



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org