Zeoslib Portal

I think the Zeos license is called LGPL with linking exception... http://en.wikipedia.org/wiki/GPL_linking_exception After doing some more research on LGPL, I see now the advantages that LGPL provides the Zeos project -- the ability to GPL the library at any time, while still being friendly for prop...

I'm having second thoughts over Zeos due to its LGPL license. I don't want to offend anyone. But to me, it seems Zeos would benefit by using an MPL license instead. It would be less restrictive for use in commercial applications, while still giving credit to the authors. For instance, i'm already us...

I think i'll stick with my workaround for now. FWIW there's also a way to keep the Resolver from calculating defaults... [delphi] constructor TZGenericCachedResolver.Create(Statement: IZStatement; Metadata: IZResultSetMetadata); begin ... FCalcDefaults := StrToBoolEx(DefineStatementParameter(Stateme...

I stumbled on an already existing solution. Turns out if I always set the value for every column, then Zeos is smart enough not to get default values for the columns that have not been assigned a value.

I got an idea to improve performance when doing a lot of inserting into the database. The following code in ZDbcCachedResultSet will execute a query for every row being inserted just to get the row default values. If doing bulk inserts into the same table, it shouldn't be necessary to get these defa...

I'm going to try using the ZPlainADO unit and create the database manually...

AConnection := CoConnection.Create;
AConnection.Open(...);
AConnection.Execute('CREATE DATABASE...');
AConnection.Close;

If someone knows a better way let me know. Thanks!

Please help! I found it easy to connect TZConnection to a non-existent firebird database by specifying the 'CREATE DATABASE' sql in the TZConnection.Properties property. However, how is this done with MSSQL 2005? (specifically i'm testing with the express edition). How do i connect to MSSQL and crea...

In case i'm not making myself clear, the bug will show up in LastResultSet, as it could potentially have a garbage cursor name.

I haven't yet had a need to look at this cursor value, so I haven't come across a particular bug, but thought I would pass this on anyway.

Yes that would be fine with me.
I can write that code and e-mail you a diff if you like.
I understand there is a feature freeze on 6.6 now. Is there work started on 6.7 yet?

Something I noticed might become a bug in Zeos. There is an uninitialized variable in TZInterbase6Statement.ExecuteQuery... [syntax="delphi"] function TZInterbase6Statement.ExecuteQuery(const SQL: string): IZResultSet; var Cursor: string; begin // Cursor is not initialized ... if CursorNam...

According to Firebird Support there needs to be a change to TZInterbase6DatabaseMetadata.GetSequences to account for a non-null value on column rdb$system_data in the table rdb$generators this only became a problem for me when i started using firebird 2.0 i've changed my source like so... [syntax=&q...

works now thanks.

There are several ways I can get ZeosLib to let me commit one row at a time in a TZCachedResultSet. Proposal #1: Add a new method to TZCachedResultSet, called CommitRow, which does basically what PostUpdates does, only it does it for the selected row. It would commit regardless of whether or not Cac...

TZQuery is probably more than what i need. I can see that the TZCachedResultSet has a CachedUpdates property. If I set that to true, then it satisfies most of the requirements in the example program. However I still need a way to save/commit each domain object independently. I'll look at it some mor...

In the example code, I need to be able to save each domain object individually, regardless of whether or not other domain objects have modified their row data. When this domain object is saved, it is actually committed to the DB, however at the same time there may exist other domain objects that hav...