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
select sum(item_id) into :It from item ;
if SQLCA.SQLCode = -1 then MessageBox("SQL
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.
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...