Zeos 7.3 testers-thread

[miab3]

ZEOS 8.0.0 trunk svn 7310
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/
NEW component ZMemTable
Compiles:

- Lazarus 2.0.0(fpc 3.3.1)? - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.6(fpc 3.0.4) x86 64-linux-gtk2 - Ubuntu 20.04 LTS on Windows 10-64 Hyper-v,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.10(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2007,
- RAD Studio XE2 -Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.1 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, PostgreSQL, MariaDB, MySQL, Oracle, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[brunodelmondes]

Hi guys!

I just installed Zeos SVN 7315 on Delphi 2010 for testing ZMemTable, then I wrote some code:

ZQuery.ReadOnly := false;
ZQuery1.Open;
ZMemTable1.EmptyDataset;
ZMemTable1.CloneDataFrom(ZQuery1);
ZMemTable1.Open;
ZQuery.Close;

After that, I tried to post changes on ZMemTable1 then I got 'Operation is not allowed in READ ONLY mode' exception.

Did I do something wrong here?

There's one more question... Will ZMemTable be able to persist changes on a ZQuery for commiting them on the database?

Thank's in advance!

[aehimself]

We need more details on this. Calling .Post after .CloneDataFrom makes no sense, please copy all relevant code.

Also, please open a new topic under ZeosLib 7.3/8.0 Forum, this thread is for test results.

[miab3]

We need more details on this. Calling .Post after .CloneDataFrom makes no sense, please copy all relevant code.

Makes sense.
After all, there is all the code.

I also give ZMemTable1 READONLY table:

procedure TForm1.Button2Click(Sender: TObject);
begin
ZMemTable1.CloneDataFrom(ZTable1);
ZMemTable1.Edit;
ZMemTable1.Post;
end;

Michał

[brunodelmondes]

Hello @aehimself!

Also, please open a new topic under ZeosLib 7.3/8.0 Forum, this thread is for test results.

I'm sorry, I'll do it.

Thank you for your reply!

[aehimself]

procedure TForm1.Button2Click(Sender: TObject);
begin
ZMemTable1.CloneDataFrom(ZTable1);
ZMemTable1.Edit;
ZMemTable1.Post;
end;

Well, checking relevant code from @brunodelmondes (and adding .Post) would look like this:

Code: Select all

ZMemTable1.EmptyDataset;
ZMemTable1.CloneDataFrom(ZQuery1);
ZMemTable1.Open;
ZMemTable1.Post;

Which - as I mentioned - makes no sense. I'll attempt to look into the read-only issue (if it is one, maybe .Clone actually places ZMemTable in a read-only state - I don't know, I always copy data manually) once the new thread is opened.

[miab3]

@aehimself,

For the current(svn7319) CloneDataFrom my code is valid, it does what you do needlessly (close, clean, copy structure and data, and open). Only that unfortunately creates a READONLY dataset.

Michał

[miab3]

After svn 7322, ZMemTable after CloneDataFrom can be READ WRITE.

Michał

[miab3]

ZEOS 8.0.0 trunk svn 7322
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)? - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.6(fpc 3.0.4) x86 64-linux-gtk2 - Ubuntu 20.04 LTS on Windows 10-64 Hyper-v,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.10(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2007,
- RAD Studio XE2 -Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.1 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, PostgreSQL, MariaDB, MySQL, Oracle, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)
TZMemTable.CloneDataFrom - works

Michal

[marsupilami]

I always copy data manually

Do you have some generic code for this? If that is the case, can you publish it? I think it would extend the use case of TZMemTable to be able to copy from any dataset and not only from Zeos datasets.

[aehimself]

Do you have some generic code for this? If that is the case, can you publish it? I think it would extend the use case of TZMemTable to be able to copy from any dataset and not only from Zeos datasets.

See this post. But be aware - I remember @Egonhugeist had issues loading a dataset with this method before. It works like a charm with Delphi and Zeos 8 though.

Edit:

"complete code" looks like this:

Initialization, copying fielddefs:

Code: Select all

Var
 a: Integer;
Begin
 For a := 0 To SourceDataSet.FieldDefs.Count - 1 Do
   ZMemTable.FieldDefs.Add(SourceDataSet.FieldDefs[a].Name, SourceDataSet.FieldDefs[a].DataType, SourceDataSet.FieldDefs[a].Size, SourceDataSet.FieldDefs[a].Required);

Copying a record:

Code: Select all

Var
 a: Integer;
Begin
 ZMemTable.Append;
 For a := 0 To SourceDataSet.Fields.Count - 1 Do
  ZMemTable.FieldByName(SourceDataSet.Fields[a].FieldName).Value := SourceDataSet.Fields[a].Value; // or .AsBytes
 ZMemTable.Post;

[miab3]

ZEOS 8.0.0 trunk svn 7337
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)? - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.6(fpc 3.0.4) x86 64-linux-gtk2 - Ubuntu 20.04 LTS on Windows 10-64 Hyper-v,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.10(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2007,
- RAD Studio XE2 -Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.1 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, PostgreSQL, MariaDB, MySQL, Oracle, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 trunk svn 7339
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles and runs:

- Lazarus 2.0.6(fpc 3.0.4) x86 64-linux-gtk2 - Ubuntu 20.04 LTS on Windows 10-64 Hyper-v,
- Lazarus 2.0.10(fpc 3.2.0)-Win64,
- NEW:Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2007,
- RAD Studio XE2 -Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.1 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- NEW:Delphi 10.4.2 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing)

Tested: SQLite, Firebird, PostgreSQL, MariaDB, MySQL, Oracle, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[aehimself]

Just a small heads up, Zeos seems to work properly in Delphi 10.4.2 x86, x64!

[miab3]

@aehimself,

This is what I wrote a week ago(see above).
However, it is more interesting that since version Z8 svn7351 has stopped compiling in D10.3.3 Android32/64.
More precisely from svn7350. It's about AnsiChar.

-------------------------------------------------
ADD: After Z8 svn7364(7363) is already compiling.

Michał