Zeos 7.3 testers-thread
Re: Zeos 7.3 testers-thread
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
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
-
- Fresh Boarder
- Posts: 24
- Joined: 28.10.2020, 15:12
- Location: Brazil
Re: Zeos 7.3 testers-thread
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!
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!
Bruno Delmondes
Re: Zeos 7.3 testers-thread
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.
Also, please open a new topic under ZeosLib 7.3/8.0 Forum, this thread is for test results.
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Re: Zeos 7.3 testers-thread
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ł
Last edited by miab3 on 11.02.2021, 20:03, edited 1 time in total.
-
- Fresh Boarder
- Posts: 24
- Joined: 28.10.2020, 15:12
- Location: Brazil
Re: Zeos 7.3 testers-thread
Hello @aehimself!
Thank you for your reply!
I'm sorry, I'll do it.Also, please open a new topic under ZeosLib 7.3/8.0 Forum, this thread is for test results.
Thank you for your reply!
Bruno Delmondes
Re: Zeos 7.3 testers-thread
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;
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Re: Zeos 7.3 testers-thread
@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ł
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ł
Re: Zeos 7.3 testers-thread
After svn 7322, ZMemTable after CloneDataFrom can be READ WRITE.
Michał
Michał
Re: Zeos 7.3 testers-thread
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
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
Last edited by miab3 on 12.02.2021, 18:41, edited 1 time in total.
-
- Platinum Boarder
- Posts: 1939
- Joined: 17.01.2011, 14:17
Re: Zeos 7.3 testers-thread
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.marsupilami wrote: ↑12.02.2021, 17:22Do 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.
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);
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;
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Re: Zeos 7.3 testers-thread
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
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
Re: Zeos 7.3 testers-thread
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
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
Re: Zeos 7.3 testers-thread
Just a small heads up, Zeos seems to work properly in Delphi 10.4.2 x86, x64!
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Re: Zeos 7.3 testers-thread
@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ł
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ł