Powerbuilder + MySQL

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 402,372 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,059 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 1577 | Replies: 2

•

Join Date: Feb 2007

Posts: 2

Reputation: prashant_nirgun is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

prashant_nirgun prashant_nirgun is offline

Offline

Newbie Poster

Powerbuilder + MySQL

Feb 10th, 2007

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

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 2,226

Reputation: peter_budo is a jewel in the rough

Rep Power: 10

Solved Threads: 270

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: Powerbuilder + MySQL

Feb 10th, 2007

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

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.

•

Join Date: Feb 2007

Posts: 2

Reputation: prashant_nirgun is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

prashant_nirgun prashant_nirgun is offline

Offline

Newbie Poster

Re: Powerbuilder + MySQL

Feb 10th, 2007

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.