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
