Topic: Whenever I run SQL statement in script of Power Builder, I get an error message 'Out of memory'. Would any DX tell me what I can do with it? Thanks a lot. @佛州华人论坛:佛州枫下论坛 The Rolia Forum of Florida

工作学习 / IT技术讨论 / Whenever I run SQL statement in script of Power Builder, I get an error message 'Out of memory'. Would any DX tell me what I can do with it? Thanks a lot. -cool(cool); 2002-10-11 (#792888@0)

More detail please. You run application or just the sql statement in PB IDE? Maybe just too many rows to be retrieved, try to add some filter -cloud2001(卷云溶月); 2002-10-11 (#792938@0)

Thank you for your reply. Go in for details...Actually I just ran couple of simple 'select into' statement directly in screen event script. After I get 'out of memory' message, the whole PB is dead. The same thing happens to exe file I created. And the same on different computers which are running 95, 98 and NT4.0. I tried to use dynamic SQL, same thing. But the interesting thing is, under my company's PB, it runs fine! Both are PB6.51. -cool(cool); 2002-10-11 {399} (#793066@0)

Havn't met this problem before, What is your database interface, odbc or oracle or sql server? -cloud2001(卷云溶月); 2002-10-11 (#793157@0)

Have you tried to run your sql statement in db administration ( database toolbar) without 'into'? Can you get the result or error message? -cloud2001(卷云溶月); 2002-10-11 (#793172@0)

That's an idea. I'll try it. (Not home now) Thanks a lot. -cool(cool); 2002-10-11 (#793189@0)

I'm wondering if my ODBC driver is old. Do you know how to upgrade it? -cool(cool); 2002-10-11 (#793166@0)

Maybe, don't forget to compare the odbc configuration of your company's with yours. for microsoft odbc, try micrcsoft's website, I am not sure if there are some staff for you to download, but it should be. -cloud2001(卷云溶月); 2002-10-11 (#793201@0)

Yeah, I tried MS website before but couldn't find anything. Sybase either. -cool(cool); 2002-10-11 (#793215@0)
Datawindow (with or without argument) works pretty well which made me even more confused. Are datawindow and SQL in script handled in different ways in PB? -cool(cool); 2002-10-11 (#793221@0)

I tried DB admin in PB and found that PB dies when I use max and min function in SQL. I don't know why but I worked it around to use cursor and order by instead. Everything is OK now. Thank you so much for your help! -cool(cool); 2002-10-15 (#798497@0)

It is good to know some colleagues using PB too. Glad to know you've solved the problem, but I don't understand why you could not use max and min, maybe it is not a single-grouped statement? -cloud2001(卷云溶月); 2002-10-15 (#798516@0)

@Florida