Zeoslib Portal

The problem seems to be solved.

After applying the patch, posting the queries now works without error messages. The % has disappeared from the "find primary key statement", as I can see via SQLMonitor.

Thanks

Gregor

Ok, I'll edit it manually.
I only had a short look on it. Do I need to apply the patch to ZDbcInterbase6Metadata.pas even when working with PostGreSQL?.
I Think, I have to reinstall the whole Zeos-Components after that (like a fresh install), right?

Best regards

Gregor

Hello mdaems,

I'll have a look an that.
I'm not that familiar with patching your components: Could you please tell me in short how to apply this patch the easiest way?

Best regards

Gregor

Hi Michael Yes, I think it is the function ConstructNameCondition in the TZSQLMetadata-Component which is used to define the variable TableNameCondition for that SQL-Statement (and others) in ZDbcPostgreSqlMetadata.pas and analog db-components. Maybe, it would be better not to use this function in t...

I think I know the problem now. I checked both with the ZsqlMonitor. In my case, I have tables in my databese with similar names, like: My_Table My_Tableextension1 My_Tableextension2 etc. The problem is how version 7.1 is determining the primary key: Old Zeos: SELECT NULL AS TABLE_CAT, n.nspname AS ...

Hello, I've got the same error message when posting certain zqueries with Postgresql 9.1 and Zeos DBO Stable 7.1.2. Old environment without error messages: Postgresql Server 8.4, Delphi 2006, Zeos DBO-6.6.1 beta New Environment: Postgresql Server 9.1, Delphi 2006, Zeos DBO Stable 7.1.2 In my case, I...

Hello,

I get an error message "undeclared identifier EZSQLException" with ZDBO 6.6.1 - beta and Postgresql 8.1 while trying to use "on E: EZSQLException do".
Do i need to include anything before, e.g. a unit?