Zeoslib Portal

Thanks for your reply.

Yes, I am using Dialect 1 on FB2.1 But I don't think it's BIGINT problem because I never have this error when I was working with IBX.

I will do more investigation for this Blob_edit.

Cheers,

Tao

Yes, it's the DataProvider who suppose to generate the update/insert sql statement base on the TableName. But it seems like the TZGenericCachedResolver.DefineTableName is call to check the TableName before TDataProvider try to generate the SQL statement for the TZQuery. I believe this is good featur...

Hi I am using the latest Fb 2.1.1, D6 SP1 and Zeos 6.6.3 under Vista business Here is my ZConnection settings: Protocol = 'firebird-2.0'; TransactIsolationLevel = tiReadCommitted; Properties.Add('dialect=1'); Everything working fine when running the application (It's a DataSnap dcom server), but whe...

Hi Mdaems, Thanks for your help again. Yes, once I use a ZUpdateSQL with ZQuery, everything works fine. But I just wondering, why ZQuery always need to check the TableName before PostUpdates, as DataSnap can create update query. Is it possible disable this feature by such as Disable/Enable property?...

Hi I am using latest Zeoslib with D6 SP1 and Firebird 2.1. I am try to convert IBX to ZeosLib. But I find ZeosLib not working with DataSnap quite well. I use ZQuery <-> DataProvider <-> ClientDataSet for update/insert etc. In the ZQuery, my query looks like this: SELECT MODULE_TASKS.*, P.THUMBNAIL F...

Hi

Thank you for your reply. The problem is I haven't set the ZConnection dialect=1, so it don't understand the 'Now' function. Once I set ZConnection property dialect=1, everything works fine.

Hi I am new for ZeosLib. I try convert my app from IBX to Zeoslib. I am using D6 with Fb 1.5. Here is my query: Select * from USER_SESSION where ('Now' - LastPageTime) > (1/60) It works fine under IBX, but it raise EZSQLException: -206 Column unknown Now unknown ISC error 336397208 It seems Zeoslib ...