Zeoslib Portal

it's happen because the MySQL server timeout setup is too small, so setup the configuration in my.ini (Windows) or my.conf (Linux)... if you can't setup them, you can check the connection before run Query by

if not (TZConnection.connected) then TZConnection.Connect;


CMIIW

I Have inserted UpdateObject with TUpdateSQL in my Zquery... this application can work in Zeos 6.5.1... but after i have used zeos 6.6.1 it didn't worked. and this is the other case zquerymaster:='select * from tbl_master'; datasource1.dataset:=zquerymaster; zquerydetail.datasource:=datasource1; Zqu...

the same case, when i have added another form in delphi..... and a query use another form it must be close......
i think it is a bug...
for the solution onClose event i have added zquery.close;

you have to change the zquery.sql.text with the simple query.. like 'select * from tbl_a'

I use Zeos 6.6.0

i have added TZUpdateSQL.. but still error? why? when i have a complex query text like 'select a,b from tbl_a a inner tbl_b on a.key=b.key inner join tbl_c on c.key=a.fkey'; and ZUpdateSQL.ModifySQL.text='update k set k.name=:name where k.id=:k.id_OLD'; it doesn't work... the record did not updated....

For the moment we are speaking about the alpha version you can get from svn (testing branch). See other posts for details about this. CVS isn't used anymore.
You can get a quite recent copy at http://users.telenet.be/mdaems

Mark

Thank 4 ur info... i'll try to download this version...

what kind of zeos.....? 6.5.1 alpha or rework?
i have run store procedure in console and it's working
but if i run in zeos error....
the statement like this....
call name_store('param');