Zeoslib Portal

A typecast is needed in TZInterbase6Connection.CreateNewDatabase to convert the SQL parameter to an AnsiString. The sc_dsql_execute_immediate call expects and PAnsiChar and is getting a pointer to the UnicodeString (see modified version below). procedure TZInterbase6Connection.CreateNewDatabase(cons...

Mark, Thanks for SVN URL's. Good to see some movement at least in the area of patches. I posted some bug reports / patches to the bug tracker on SF some time ago, but don't think they were ever corrected. If you search the forums for "Firebird 1.5 and BLOB (as text)" you will find one of t...

Mark, Thanks for the update. What is the URL for the new SVN repository? I saw mention that development has moved to SVN but don't recall seeing a URL posted. Is this a new SourceForge SVN repository or located somewhere else? I would also be interested in understanding the longterm goals and plans ...

Michael,

I posted a PM to you some time ago about contributing to Zeos but have received no reply. Anything happening with Zeos recently?

David

Sounds good to me. I have posted a request to Michael to join the Zeos team but have not heard a response yet. I like using Zeos and want to see it improve...

David

Just checking if anyone has worked through the details of using positioned deletes (or updates) with Zeos and Firebird. I can see there is a mechanism for defining the cursor name for a query result set. When I try to set the cursor name I get an AV since the underlying DbcStatement object does not ...

Yep, the comments on querying system tables are right in target. This is how Zeos implements GetTableNames. The problem is that the wildcard expressions supported by the LIKE comparison operator conflict with legal table names. This is how the issue came to light, I normally uppercase my table names...

IMPORTANT NOTE: If you are using GetTableNames with the IB/FB protocol (maybe others) there is a subtle but important bug (feature?) that may bite you. The Pattern passed to the GetTableNames method treats "_" and "%" as wildcard characters. The choice of these particular charact...

Ideally this needs to be configurable since the library name depends on your configuration. I often work with the embedded version of Firebird 1.5 which uses fbembed.dll. Some users also rename fbclient.dll to gds32.dll for various reasons. While we are at it, Firebird 2 support should be added. I a...

The leak is caused by a known bug in ZDbcInterbase6Utils. The problem is in the WriteBlob(const Index: Integer; Stream: TStream) of TZParamsSQLDA. If you are feeling adventurous, the fix is simply to add a try finally block and a call to FreeMem as shown below: ..... ..... Buffer := AllocMem(BlobSiz...

If its any consolation, I have used or looked at most of the Delphi DB libraries available and selected Zeos. My main consideration was the ability to support many SQL databases with one library. I have used Zeos extensively with firebird 1.5 in two commercial applications and it has performed very ...