Zeoslib Portal

marsupilami wrote: ↑04.04.2023, 11:50 I think we fixed that one. Could you please check if the current revision of Zeos 7.3 from SVN works?

Now, its work fine. Thanks.

marsupilami wrote: ↑04.04.2023, 12:05 I applied the patch. Thank you

Thank you too

Could you please test if it works? Yes, now its ok, thanks. I'll add more so I don't create a new topic. When ZConnection.Reconnect or after lost connection I do ZQuery.Close and ZQuery.Open. And If query has parameters, then an error occurs, because query text is garbled. I think that TZAbstractDB...

Hi, when displaying a column with a type VARBINARY(MAX) in MSSQL Server, an error occurs in ZDbcCache.pas: stBytes: if (FColumnLengths[ColumnIndex] <= 0) or (FColumnLengths[ColumnIndex] = MaxInt) then Result := TZRowAccessorBytesLob.CreateWithDataAddess(PZVarLenDataRef(TempBlob), zCP_Binary, ConSett...

If I understand correctly, when the connection is lost, the following procedures are called: 2022-06-27_12-10-53.jpg In procedure TZAbstractStatement.ReleaseImmediat value FClosed set in True. And when the procedure TZAbstractStatement.Close is called, it does not go to the line: FConnection.Deregis...

I am attaching screenshots related to connection loss error. Error AV occurs on the line 1470 in module ZDbcConnection: procedure TZAbstractDbcConnection.CloseRegisteredStatements; var I: Integer; begin for i := fRegisteredStatements.Count-1 downto 0 do begin //try IZStatement(fRegisteredStatements[...

i have problem with lost connection too. but a have connect to mssql. I copyed your code and little changed: program project1; {$mode objfpc}{$H+} uses {$IFDEF UNIX} cthreads, {$ENDIF} Classes, SysUtils, ZConnection, ZDataSet, ZDbcInterbase6Utils, zcomponent; var Connection: TZConnection; Query: TZQ...

Did that help? No, Integer values are still displayed with a separator. The program does not stop at a breakpoint in the SetAsBCD procedure, although it does stop at TZFMTBCDField.GetText. I think the procedure TZFMTBCDField.SetAsBCD is not being executed. To be fair it would be nice if you file a ...

EgonHugeist wrote: ↑12.02.2021, 05:53 Brick08 any news on this?

Now it's ok, thanks.

Hallo. I will also add.
In TZMemTable when displaying fields of type TZRawStringField, the program gives an error AV. See screenshot.

In order not to create a new topic, I will write here.
When setting a column property DisplayFormat = '0.#', for FMTBCD type fields, integer values are displayed with a separator, although BCD type fields are displayed without it.
Can you fix this?

marsupilami wrote: ↑15.01.2021, 09:28 Could you please check if that solves your problem?

Yes, now it's all right. thank you.

EgonHugeist wrote: ↑13.01.2021, 18:15 As an alternative you can define your own format to represent the values i guess?

Even if i use DisplayFormat = '#0.#', zero value in FMTBCD still shows how '00000000.00'.
I just want to display '0' for default in FMTBCD fields.

marsupilami wrote: ↑13.01.2021, 09:46 TBCDField internally uses the Currency data type. It can hold up to 4 decimal digits. So Zeos uses it for Numeric(18,1) to Numeric(18,4)

No. Zeos autocreated as TBCDField only Numeric(18,4), and Numeric(18,1),(18,2),(18,3) it created as TFMTBCDField.

I attached small example. See it, please

Hi all. I have MS SQL Server 2019, Lazarus 2.0.10 and Zeos 8.0 last trunk. I create fields on the server, for example NUMERIC(18,5). It is defined as TZFMTBCDField. When displaying in grid, the value is 0, its look like as '00000000.00'. Although a TZBCDField look like as '0'. I noticed that after u...