Zeoslib Portal

your solution works for me too.

in ZDbcDbLibMetadata.pas in "function TZSybaseDatabaseMetadata.UncachedGetTables" in the "with GetStatement.ExecuteQuery" statement, a "format" is used the last parameter of that format statement is : ComposeObjectString(TableTypes, '"') the function declaration fo...

as far as I can tell, underscores are allowed in TableNames in all databases, but the %-sign is not (not even if you escape the table name with brackets) So instead of changing the "like" to "=", I opted for a more subtle solution : in ZDbcMetadata.pas, in TZAbstractDatabaseMetad...

I have an Oracle database that contains 2 tables : - T_ALERT - T_ALERT_ENVIRONMENT The first field in both tables is identical : ID (integer) When I perform this query : select * from SYAL.T_ALERT then I get the following error : cannot update a complex query with more then one table. This is obviou...

I think there is a bug in ZDbcDbLibMetadata.pas (revision 3115) in TZSybaseDatabaseMetadata.UncachedGetTables : a call is made to ComposeObjectString with only 2 parameters : ComposeObjectString(TableTypes, '"')) I think this should be : ComposeObjectString(TableTypes, 'null', '"') and the...

the Sybase sp_help procedure returns multiple resultsets, but the actual reply is in the very first resultset. In SQL Advantage (the Sybase client program to execute queries), you get for example this answer : (373 rows affected) (0 rows affected) (0 rows affected) (0 rows affected) (return status =...

I need this only once for only 1 specific Oracle DB, so your solution is more than enough for me. Thank you.
(sorry for the probably silly question, I am still a little new to Zeos)

When performing a "select *" query on an Oracle Table with a huge number of fields, I noticed that the query was really slow (several minutes). After contacting our DBA's, they told me to set the Prefetch Rows to a higher number. I could not find this option in ZeosLib (but I might be over...

Agreed. My \; approach was not that good.
I like your #9 solution.
Thanks for the fast reply and excellent idea.
Looking forward to seeing it implemented.

one of our databases has a db-account that has a ; in the password (I am not the DBA and can not change this password) As ; is used as a separator to pass information between the zeos objects, the password gets truncated at the ; sign. To solve this, I have changed some code in zsysutils.pas (revisi...