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 at all...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 fine....but 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 that....also 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