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

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

Try

SELECT sum(serialno) as iii_int FROM Applicant;

Unless that other syntax is some Powerbuilder thing. It's not SQL.

John Bonnett

-----Original Message-----
From: Rick_Zhang [mailto:rickchina@263.net]=20
Sent: Monday, 16 May 2005 4:33 PM
To: myodbc
Subject: 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=3D-1
sqlca.sqldbcode=3D1305:SQLSTATE=3DS1T00
sqlca.sqlerrtext=3DFUNCTION 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=3Dgcdmo-myodbc@m.gmane.o rg