Zeoslib Portal

..continued..

Its inlcuded for windows and you have to rename to libmysql50.dll if using from own distri.

Hm, looks pretty ok for me.
What happens if you leave the "close" 's out.

If you only use ExeSql, you don't have to close a query.
Did you use TZquery for qInsert, or else?
How does your init part look like, or did you complety used dropping and setting of zeos object properties in object inspector ?

Ahh, looks like the articel i just found in web in german

Do you really have to select the whole table?
I am not sure if the Query is the best component to do so, i think there was some table comps also.
Which database do you use? Interbase?

Did you run "ReadOnlyQuery.Execute" or "ReadOnlyQuery.Open"?
You should have done "Open."

I also agree to do some rework and structure refreshing for the orion portal.
If you need help here, i am experienced with that - Tx for the good support cback offers

You have to define use charset UNICODE_FSS when creating firebird database file. Using following code (untested) should create the needed db file: ZConnection.Properties.Add( 'CreateNewDatabase=CREATE DATABASE 'C:\firebirddb.FDB' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 4096 DEFAULT CHARACTER SE...

http://cforce.dnsalias.org/files/spec_clearcache.patch Patch done. You can do specific cache clear, like see below. Code untested, please reply if it works. uses ZDbcMetadata; List :=TStringList.Create; ZConnection.Connect; ZConnection.GetTableNames('',List); ZConnection.DbcConnection.GetMetadata.Cl...

I added this strict dll loading compiler switch and exported WINDOWS2 Const defs to new unit called ZPlainFirebirdDriver. Did some code seperation, the fb driver class now also is in ZPlainFirebirdDriver, common used code of Firebird+Interbase residy in "ZPlainFirebirdInterbaseConstants". ...

Really not in there, well ok. Zip contains libs for fb15 and 2.0 for windows.
Would be greate if someone out there can make a unix bundle, i never used it on unix and have no idea what exactly is needed (in worst case).

http://cforce.dnsalias.org/files/firebird2.zip

Sry, i don't agree. If using zeos as multi RDBMS api i offer m app with all this dbs. I have no idea what db will be taken and threfore don't want to make if else decision for every code piece called in api depending to decide how Starttransaction is undertstood this time. For the new version i will...

That is true, you have to rename the libs at the moment. For embedded you had on windows always to do also in mysql for both versions, so it doesn't seemed to strange to me to expect. But using espcape names makes sense, its just firebird drivers hadn't non strict dll loading before. Anyone who want...

The binary files (dlls, and things) are for easy using zeos - no need to download two firebird distris and rename files , else we will need a howto!
Sry for the svn dir, i thought i removed it from zip.

Why copyrights - Firebird ist open source i thought?

I needed some modifications and enhancements of a trashy tool you supplied with examples, as far as i know. If someone needs, here is the source
DbTool