Zeoslib Portal

Thanks for your remind. I have post it on bugtracker as issue 0000155.

Hi, I am using ZeosLib 6.6.4, D6 and Firebird 2.1 with latest FastMM4 4.90 And the FastMM4 fulldebugmode report hugh memory leak on ZeosLib components. I have write a very simple test app using Firebird 2.1 default Employee sample database as test case and get the same memory leak result. I have att...

Hi, I am using ZeosLib 6.6.4, D6 and Firebird 2.1 with latest http://sourceforge.net/projects/fastmm/%20FastMM4%204.90 And the FastMM4 fulldebugmode report hugh memory leak on ZeosLib components. I have write a very simple test app using Firebird 2.1 default Employee sample database as test case and...

Thank you for both explanations.

I haven't use TQuery for years and already regard it as a read-only dataset as TIBQuery in the IBX.

Hi, I am using Zeos 6.6.4 with Firebird 2.1 I have a little bit confuse about how to use ZQuery with ZUpdateSQL. I used to put a ZQuery and ZUpdateSQL into the Form, and set ZQuery.UpdateObject to the ZUpdateSQL. Then set the Insert/Update/Modify/Delete/Refresh SQL under ZUpdateSQL component for upd...

Yes, I can because my database dialect is 1. I am using FlameRobin as my db admin tool.

Hi Mdaems, I have tested your patch, it works fine after I add one more condition on it: + IF (UpperCase(DefaultValue)= '''NOW''') or (UpperCase(DefaultValue)= '"NOW"') then And also wonder, because this change only happen after Firebird upgrade to 2.0, so what happen if ZeosLib connect to...

Thank you very much, Mdaems. I will checkout the latest patch from svn.

Interesting. When I using 'Now' in trigger, NEW.LASTUPDATED = "Now"; It do return a date/time type for me without error. But when I do select 'Now' from rdb$database It return a string 'Now' as Firebird manual's description. But I will change 'Now' to CURRENT_TIMESTAMP as you suggestion. T...

Hi Seawolf, Firebird do have a build in "now" function. And as my first post mention, it works fine under IBX component. If you have a look the TZRowAccessor.GetTimestamp I posted, you can see its default return value is 0. As in ADO.Net 1.1, it also set 0 as DateTime default value. That's...

Good point, btrewern. Thanks for your suggestion.

Hi, I am using zeoslib 6.6.3 with Firebird 2.1. I try to convert my app from IBX to ZeosLib. My table like this: CREATE TABLE APP_MODULES ( ID INTEGER NOT NULL, VERSION INTEGER NOT NULL, LASTUPDATED TIMESTAMP DEFAULT 'Now' NOT NULL, PRIMARY KEY (MODULEID) ); CREATE TRIGGER APP_MODULES_LASTUPDATED FO...

Thanks for your quick reply, Mark. I will try it out next week as I am busy other project at the moment.

By the way, what's the Url of the Zeoslib svn? I think the sourceforge cvs is very old.

Cheers,

Tao

Hi, I am using ZeosLib 6.63 under D6 SP1 under WinXP. The SqlMonitor works fine for me. The only issue is that it don't log the query parameters values. Is this by designed? Because in .Net side, I am using nhibernate and log4net, it's very handy to trace sql log with query and parameters. Cheers, Tao

Hi If you have a look the error trace again: 2008-08-29-10:10:38 2008-08-29-10:10:38 ExceptHandler(EZSQLException: Cannot update a complex query with more then one table, 00521CAD) [00521CAD] ZDbcGenericResolver.TZGenericCachedResolver.DefineTableName (Line 289, "ZDbcGenericResolver.pas") ...