Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBuilder

Can you please specify what problem? You just start sentence and cut it in middle :cheesy:

I found most of aggricate functions like sum, min and max are not working in powerbuilder script. it works fine in database administrator. but in power script if we tried to stored result in a variable it bangs wait i will note down the error message

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.