Zeoslib Portal

Please don't use cached updates. Use a transaction instead. Can I have a little example of use transaction instead a CachedUpdates? Normally I have few master records with large details per single master row. CachedUpdates will not combine the updates into one query. It will just generate a lot of ...

marsupilami wrote: ↑27.04.2021, 21:07 I think, it really depends on the value of ZQuery1DATA_REGISTRAZIONE.Value when that happens. What is the value of ZQuery1DATA_REGISTRAZIONE in the database?

The value is entered via the keyboard, example: "27/04/2021".

Do you use firebird or interbase as the protocol?

Firebird.

Thanks.

Hello, Until today, with Zeos 7.2.0b, I programmed a master/Detail scenario using only with "DataSource" property of detail ZQuery and manually I managed alla statements to Post, Delete, Cancel without any automatism managed by Zeos code. Now due to larges modify made by version 8.0 the ap...

Hello, I try to upgrade my application from Zeos 7.2.0b to 8.0.0-r7490. This code present in the OnValidate event of the column DATA_REGISTRAZIONE: procedure TForm11.ztbDocTestaDATA_REGISTRAZIONEValidate(Sender: TField); begin zquery1DATA_DOCUMENTO.Value := ZQuery1DATA_REGISTRAZIONE.Value; end; I ob...

Forgive me , I found the mistake, my mistake! The problem was not the parameter of type "TDate" but another parameter (DT.NUMERO = :Numero) of type "String" but passed for "Integer" even if the error came out only deleting the line of code: query1.Params.ParamByName('D...

Hello marsupilani,
both column are defined as "DATE":

in table AZIENDA, the column is defined as:

DECORRENZA Date NOT NULL

in table DOC_TESTA, the column is defined as:

DATA Date

The only different is that AZIENDA.DECORRENZA is PRIMARY KEY

Database is on a Dialect 3.

Thanks.

If I change the query like this: UPDATE DOC_FE DFE SET DFE.STATO = :Stato WHERE DFE.STATO < :Stato AND DFE.DOC_TESTA_ID = (SELECT DT.ID FROM DOC_TESTA DT, TIPO_DOCUMENTI TD WHERE DT.DOCUMENTO_ID = TD.ID AND TD.DESCRIZIONE = :Documento AND DT.NUMERO = :Numero AND DT.SERIE = :Serie AND DT.DATA = '01.0...

Hello, I try to update my application from Zeos 7.2.0b to new 8.0.0 but I have first trouble. I have this query: UPDATE DOC_FE DFE SET DFE.STATO = :Stato WHERE DFE.STATO < :Stato AND DFE.DOC_TESTA_ID = (SELECT DT.ID FROM DOC_TESTA DT, TIPO_DOCUMENTI TD WHERE DT.DOCUMENTO_ID = TD.ID AND TD.DESCRIZION...

marsupilami wrote: ↑24.04.2021, 08:30 Usually I would use find and replace in the dfm files to just change the type information.

Do you mean:
1) view as text
2) search and replace?

Zeos8 is usable in production?

Thanks

For me, it takes 5 seconds for 1 million iterations(without crHourGlass) Zeos8 svn7460; Firebird-2.5.9.27152-0_x64; Delphi 10.3.3-Win32 on Win10-64 :) I have a problem to install Zeos8 because in this project I need to replace hundred of TFloatField to TBCDField but those TFloatField often have a V...

marsupilami wrote: ↑23.04.2021, 13:53If you didn't disable the SQLHourglass cursor on the connection, try the following code:

Takes more than 1 second longer

Thanks

You could try to see what happens when you use the Zeos 8.0 Beta. At a moment I cant try with this version, :( t also really depends on the data that is loaded into the dataset. Data fields are: Integer x 2 Smallint x 7 Char(29) x 2, Char(4) x 1, Char(2) x 1, Varchar(480) x 1, Varchar(10) x 1, Varc...

This code, with Delphi 2010 and FB 2.5.9, takes 11 seconds to complete: begin Cursore := Screen.Cursor; Screen.Cursor := crHourGlass; Result := 0; bmBookmark := ADataSet.GetBookmark; ADataSet.DisableControls; try ADataSet.First; while (not ADataSet.Eof) do begin if (ADataSet.FieldByName(AField).AsIn...

marsupilami wrote:it seems that EgonHugeist checked in a solution. Could you please check if the problem is solved in the current 7.2-testing branch on SVN?

Ok, now in both cases I get a field of type TExtendedField.

But, why, in Zeos, is not safe to use TCurrencyFields?

Thanks.

Regards.

when I remove it and readd it will stay same type TFloatField ... we had to revert it, i'll check it again this week Have a look for this topic http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=92611 . I've got the same problem updating from Zeos 7.2.0b to 7.2.4-stable. I get TFloatField in o...