Zeoslib Portal

Hi Jan, Sorry, you are right. I was testing a "ON DELETE CASCADE" and with "foreign_keys=ON" seemed to be working, but I think I misleading something when checking it with sqlite3.exe command line tool. I've just retested again and "foreign_keys=1" works. On the other h...

Hi All, I experienced a difference in behavior with ZeosLib 7.2.0 Beta. 1. Using Firebird With a Firebird 2.5.2 simple database, the FLOAT fields are interpreted (I think), by ZeosLib, differently in C++Builder (RAD) 2009 and C++Builder XE2. I tested in a Windows 7 64 bits OS. In C++Builder RAD 2009...

Hi, Just for confirmation using C++Builder: ZConnection->Properties->Add("foreign_keys=1"); will activate foreign keys pragma with SQLite. But: ZConnection->Properties->Add("foreign_keys=ON"); will not . Tested with ZeosLib 7.2.0 Beta 3609 , C++Builder XE2 Pro, SQLite 3.8.11.1. B...

Jan While searching for information, I've read something about problems with wildchars. At a glance, I concluded that the char "_" plays as "%" and that was a source of problems with tables named as "TABLE_NAME". On the other hand, if TZSQLMetadata"s property "...

Hi Jan, I've tested (TableName = %) without any luck. So, following a similar thread: http://zeoslib.sourceforge.net/viewtopic.php?f=24&t=3363&hilit=MetadaType+mdColumns I've decided to change the code setting up TableName properly with the result of a ZConnection->GetTableNames() call. Here...

Hi Jan, Nice hint! It is working. The interesting part is that I've used TZSQLMetaData with Firebird and the (MetadaType = mdColumns) option list all tables and their columns, so you do not neet do set (TableName = "YourTableName"). I think this way is better, since I'm using TZSQLMetaData...

Hi, Using ZeosLib 7.2.0 Beta in C++Builder XE2 and SQLite 3.8.11.1, I wasn't able to list Columns using the TZSQLMetadata component. I've tested (MetadaType = mdTables) and it works fine, but (MetadaType = mdColumns) shows a empty ZMetaData object (via DBGrid visual component). Here are the basic pr...

Hi, I'm sorry about the last post. I now realized a mistake and I would like to share it in order to not misleading other readers. Setting "ControlsCodePage = cGET_ACP" works properly as expected. I've done a mistake into my code just before setting a "ROLENAME" property: ZConnec...

Hi, I have the same problem (please let me know if I might start a new thread): EDatabaseError: 'Type mismatch for field 'Name', expecting: String actual: WideString'. My C++Builder code is querying a Firebird 2.5 database/table with VARCHAR(20) fields, mapped as TStringFields and linked to TZQuery ...

Hi All, Could someone confirm that TZQuery and TZStoredProc parameters got duplicated in DFM files with sets named "Params" and "ParamData"? Here an example: object QryRes: TZQuery Connection = ZConnection SQL.Strings = ( 'Select * From Reservatorio Where CodUsina = :CodUsina') P...

Hi All, I'm working in a BDE to ZeosLib migration task and everything is going OK. I think I can post this experience to this community soon. So, I would like to suggest you to change the "Unprepare" method to "UnPrepare", just to calm down the C++ case sensitiveness. Unit: ZAbst...

Hi Michal, Thanks for your reply. Actually, I'm moving my applications to RAD 2009 and XE2 too. I've tested the packages with BDS 2006, RAD 2009 and C++Builder XE2 just for proofing all my IDE's installation. Please, do no take my report as an demand on ZeosDBO code. That wasn't my intention. Now, I...

Hi Michal, This is a report about BDS 2006, aiming to compile and install in C++Builder. I'll show my results as an item-based report. 1. Existing Delphi2005 Package If you open the Delphi2005's project group into BDS 2006, with Delphi personality, you are able to compile and install ZeosDBO without...

Michal, I've found the problem with my test project. Actually, I've changed an option, by mistake, in my C++Builder XE2 ZeosDBO packages. I've set "Link with Dynamic RTL" to "true". I've recompiled with this option to "false" and now the test project works with static a...

Hi Michal, (sorry about the delay). The two test projects you have shared worked fine with my installation of C++Builder XE2 and ZeosDBO. I've changed my test project to be static linked and now it is working. I have some problem with dynamic linking the ZeosDbo packages. As you did, I just created ...