0

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

2
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by prashant_nirgun
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.