Zeoslib Portal

Zeos 6.6 - beta ZSQLMetadata - mdTables dont return any value ?
it works before 6.5 ?

Muthu

Hai

i am using zeos latest source (thru svn updated ) , mysql ver 5 (but i chked with old ver of mysql also )
select sum(qty) as ttlqty from table1
return like this
ZQuery1ttlqty: TStringField;
but normlay like postgresql & others return as TFloatfield

is this bug or problem of mysql ?

Muthu

Hai

Mysql - Zquery - sum(field) return stringfield resutl, suppose to be numeric type result ?

Muthu

i can do it for delphi 7, delphi 2006 , postgresql (7.x , 8.x)

http://tortoisesvn.tigris.org/ - try this , then update.

ZConnection.Properties.Add('isc_tpb_concurrency');
ZConnection.Properties.Add('isc_tpb_wait');
is there any option like this for postgres?
for connection resume? how to find if connection droped , even after connection to server droped still connected shows True?

thanks for your reply , i am try to use some timer , refresh query works find, but i think there is some option in zconnection parameter , any idea about this.

is there any way to resume broken connection ?

Hai

i have problem in time out , for postgresql server, if we dont use for 30min connection to server will be droped.
how to disable time out?

if internet connection droped , i have to reconnect again, is there any way to reconneect & resume


muthu