Zeoslib Portal

EgonHugeist , I saw you added GetOverloadSeparator and SupportsOverloadsInStoredProcedureName to the TZDatabaseInfo interface. Let me give you some examples so you could think about the way of implementing overloads support (and see why I still didn't do it). The way you are trying to do it only wo...

EgonHugeist , miab3 , Sorry, I was too busy last week and didn't follow last changes. Michael, I can see you did a great job with multiple result sets, this is really cool! I've been thinking about overloaded functions we were talking before, and can't see a good way to deal with them. The problem ...

EgonHugeist,

Can you start it?

I'll see what I can do.

May i propose again to have an additional column on the MetaInformations? Then we can improve the quotes on the component too. We. Can check the name and the overoad.. If both exists then quote the name and append the overoad unquoted. If the overoad coumn is null then use only then name. What do y...

miab3,

can you please try revert local changes (if any ) and rebuild again, because 1726 was a fix just for MySQL and it cannot break all DACs (eventually). Besides, I work with latest revision on XE2 and don't have big problems with PostgreSQL, Firebird, MySQL and MSSQL

EgonHugeist , But i was wondering the the MySQL-IZIdentifierConvertor was not able to dequote the `P1` parameter (ExtractQuote). I did it manually. This is strange. I didn't test it, but it looks like everything is fine with it. No problem for me. I propose a new published property on the TZStoredP...

miab3,

do you know where that 'master' come from? Is it specified in your Catalog property?

I'm asking because I do my tests on SQLEXPRESS with SQLOLEDB provider, an I get [dbo].[ABTEST;1]

miab3,

thank you very much for your feedback. This confirms that we have to add extra methods to Metadata.

miab3 , This is strange, because I don't get errors when execute [dbo].[ABTEST];1 EgonHugeist , MSSQL returns names of procedures like ABTEST;1 where ;1 is not a part of procedure, but the index of overload. When quoting is applied in PropertyEditor using IZIdentifierConvertor, the whole ProcedureN...

miab3,

Btw, what Protocol we are talking about?

I propose to ask Mark befor changing this... It could have a reason, we don't know about. A reason for what? UncachedGetTables returns database(schema) name in field Catalog for years. The new UncachedGetProcedures you've recently added returned it in Schema, so I made a patch that makes both metho...

Ok, now I see where the problem is. Inavlid identifier quoting.
Should be
[master].[dbo].[ABTEST];1

miab3,

and what about MSSQL, does TZTable work in there?

EgonHugeist,

I wonder why that not happens on TZTable...

Because UncachedGetTables returns database name in catalog, not in schema.

miab3,
I fixed it in rev.1727

EgonHugeist,

I do also wonder why that happens @designtime.

This is because of data returned from MySQLMetadata. It returns database name as Schema name.

Michael, I guess we need extra method in metadata to compose qualified identifier names. What do you think?