mysql and power builder

[Adriana Reynoso]

Hi!

Thanks for your help!!!

OS: W2K nt
Server: MySQL 4.0.1 Max nt
Mysql ODBC driver 3.51
Power Builder 8.0.1.

I have 2 main problems:

1. I have a datawindow with 2 arguments, in preview mode works just
fine...but inside a window it doesn't retrieve data atall...even if
I put values instead of variables...
  this is my scrip in the constructor event of my window
 long tmp
 DatawindowChild dw_child

 If GetChild('periodo',dw_child) = -1 Then
essageBox( "error","dwchild error" )
 If dw_child.SetTransObject(SQLCA) = -1 Then
essageBox( "error","dwchild settransobject" )
 tmp=dw_child.Retrieve(st_login.empresa, st_login.ejercicio)
 /***tmp=dw_child.Retrieve(1, 2001)  ***Even if I put this
values
it doesn't work, no data is returned***/
 insertrow(0)
 SetItem(1,'periodo',st_login.periodo)
  But if I use only one argument it works fine!!!??

2. In another datawindow i'm using a SQL scrip that retrieve information
for two big tables (40,000 rows each), when i proved my datawindow with
almost
empty tables (10 records) works finebut since I filled my tables with
real data
I can't hardly check my SQL scrip because it delay at least five minutes
to show it and window send me a message "your are running out of virtual
memory"
or something like thatalso my pbtrace file says "MySQL client runs out
of memory"...
lost conection to mysql server during query
   In ini.cfg setup
   set-variable=key_buffer=16M
   set-variable=sort_buffer=1M
i'm migrating my application from ORACLE to MySQL to provide an economical
choice to my customers...i'm the only person using this application and have
the server and client in the same machine(132 MB RAM)

Hope somebody answer !!! thanks


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql & power builder

[Adriana Reynoso]

Hi again

I'm Working with PB 8.01 , mysql odbc 3.51 driver, Mysql 4.01 alpha-max-nt ,
OS Platform:w2k service pack2, using INNODB table type

I design a Datawindow using 2 retrieval arguments, in my preview seem to
works fine...but when I run my application it doesn't retrieve any data...

If I change my datawindow and use only 1 argument works fine

what could it be


Also, I have a datawindow that retrieve information from a large tables
(40,000 rows ) when I access my SQL my virtual memory runs out and all my
system down its performance my scrips delays in appear for at least 5
minutes

I have the server and client in the same machine...and only I have access to
the data...
I have 128M RAM, and in my.ini
set-variable=key_buffer=16M
set-variable=sort_buffer=1M

when I was using tables with 10 rows I didn't have the problem it started to
appered when I filled my tables with a large amount of data.


thanks in advance


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php