Zeoslib Portal

This Code

Use Zeos 8.x, Get wrong Values margin_1 or margin_2 zeos_8_test-0.jpg Use Zeos 7.2, Get Values margin_1 or margin_2 zeos_7.2_test-0.jpg when use zeos 8 value column margin_1 ----------- 25 50 25 0 when use zeos 7.2.14 value column margin_1 ----------- 250,000 500,000 250,000 what's wrong zeos 8 ? :D

with qrySQL do begin
ParamChar:='#'; //--> Ok
Close;
SQL.Clear;
SQL.Add('select now()::date');
Open;
end;

Ok Jan Thanks
Now error syntax no show

Use Zeos 7.2

select now()::date -->syntax error

but

select now()::::date -->Run

After I try again with numeric data type (19,4). DBGrid has produced what it wants.

Maybe this is my carelessness using numeric data types (22,4)

My conclusion, use numeric types only until (19, xx)

Thank you for your attention, Michael

Regards

I do not understand and can not give advice on what to do, if indeed this is a bug on fpc, I should temporarily use zeos 7.2 until the bug on fpc is resolved, but I will try to continue every release of the latest zeos 7.3 svn.

Alright, thanks a lot Michael

regards

Hello Michael,
This a small demo app with a database script psotgresql

Thanks a lot

regards

After installing and running version svn 7.3-r6491, the problem still exists

regards

I'am Sorry, for the late replay

Datatype numeric(22,4)

I will try again with the latest svn 7.3 version, as soon as possible

regards

Sorry for my incomplete explanation, I mean that zeos 7.3 does not display the value of 0 in the cell as the value of 0 displays in the cell when using zeos 7.2, it looks like the attached picture. cell format, 0.00; -, 0.00; after the last semicolon containing spaces it should not display the value...

Thank's a lot Jan
But a few problem see pict .jpg

In ZeosLib 7.3 zero value display 00,000,000.00 in cell DbGrid
use Postgresql 10
Lazarus 2.0.6
Windows 7

Furthermore, whether if there are two concurrent processes startransactions, when one commit command executed if both of the startransactions same time will affect the commit command of one of the execution of TZQuery or TZReadonlyQuery it I will try your suggestion, and it looks better if you use y...

Hello ribut, Please don't do that: with qryIUD do begin Close; SQL.Clear; SQL.Add('BEGIN;'); ExecSQL; end; The ZConnection Object has the methods StartTransaction, Commit and Rollback. Please use them because Zeos handles some things internally through them. With best regards, Jan why i don't do th...

miab3 wrote:@ribut

Could you try with autocommit disabled:

ZConnection1.AutoCommit:=False;

Michal

ok, problem solved

many thank's Michal