Zeoslib Portal

I try using ZeosDBO 6.6.2-rc, Delphi 7, Firebird 2.0.3 SuperServer, charset: None.
There is no problem, everything save well, are you use special charset or UTF8?

What database do you use and what type of field that you use?

Slavikk, what version of Zeos you are using? is it Rev305? because in that revision I see a bug in float field (the decimal part is not displayed), and I already solved it in Zeos bugtracker (bug 0000071).

It's because Zeos use TFloatField and not TBCDField. But to display correctly you must set the DisplayFormat property of the persistant field of your query to #,##0.##

yes, and in 6.6.2 version we can still use FB1.5 protocol to access FB2.0 (although it's not recommended) Maybe in 2.1 version there is some change in client API or what? I still not use 2.1 version, and I think to be 2.1 official release it take about 3-4 months (or maybe it could be more fast?). A...

What database you use?

Usually that error mean that column (NOMBRE) is not exists, please be carefull for some database like Firebird that can have case sensitive name by using "..." (surrounded that field with double quote). It depends on when you create that table

What database you're working?
mmm.. I never do like that, usually I use TZStroredProcedure or TZQuery component

I'm using Zeos with FB :) I also already ask about this topic and you also can look in http://zeos.firmos.at/viewtopic.php?t=110 There is some question: 1. Maybe you can show me which FB/IB article that said after hard commit it must be followed by start transaction? You can get the latest SVN from ...

Or try like this: select L.PARAM02, 1, L.PARAM02 one from TZAJAV Z left join TDOGOVOR D on d.ID=z.IDDogovor left join TANKETA_FIZ AF on af.ID=z.IDAnketa left join TANKETA AJ on aj.ID=z.IDAnketa, TLIZINGODATEL L where z.ID = 1 Yes, this is a serious bug. Can you add this bug into http://zeosbugs.firm...

have you try with the latest version (the URL is in below)?
http://zeosdownloads.firmos.at/downloads/snapshots/

there is a bug that I found earlier and already fixed, maybe it also fix your problem too.

hhmm.. strange, can you send the simple project that can produce that error? you can post this bug on mantis (http://zeosbugs.firmos.at/) with the sample project.

Yes, I think klchin is right, I not use BCB here (I use Delphi 7) but as I know the BCB dataset concept is same with Delphi (CMIIW). So you need to drop TZConnection (Zeos), TZQuery (Zeos), TDataSource and TDBGrid (sorry if the the name is only valid for Delphi, but maybe you can find the similiar c...

@Andy: TZStoredProcedure also can have resultset :) @Antz: I try this and it run fine (Zeos 6.6.1 beta, FB 2.0.1): Firebird Stored Procedure (using Employee database): CREATE PROCEDURE SPSELECTCOUNTRY( PCOUNTRY VARCHAR(15)) RETURNS ( COUNTRY VARCHAR(15), CURRENCY VARCHAR(50)) AS begin for select c1....

The command "show tables" is not valid DML SQL statement, you also cann't execute that query in IBExpert. If you want to get the list of the table, you can try this: ZConnection1.GetTableNames('', Memo1.Lines); //to display in TMemo component or you can query like this: select rdb$relation...

Can you attcah the sample in Delphi and your database here? So I can reproduce that error?

Thx