Zeoslib Portal

ZEOS 8.0.0 /trunk svn 7633(7634)
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-win64(on Windows 11 Pro 22000.120),
- Delphi 7(on Windows 11 Pro 22000.120),
- Delphi 2006,
- Delphi 2007(-ZBase64.pas),
- 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.2 Sp1,2,3 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

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

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

Michał

ZEOS 8.0.0 /trunk svn 7645(7646)
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-win64(on Windows 11 Pro 22000.160),
- Delphi 7(on Windows 11 Pro 22000.160),
- Delphi 2006,
- Delphi 2007(-ZBase64.pas),
- 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.2 Sp1,2,3 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

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

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

ZMemTable without ZConnect works.

Michał

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

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-win64(on Windows 11 Pro 22000.176),
- Delphi 2006,
- Delphi 2007(-ZBase64.pas),
- 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.2 Sp1,2,3 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

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

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

Michał

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

Compiles and run:
Delphi 11 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing) on Windows 11 Pro 22000.176.

Michał

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

Compiles:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64(/Android/Android64- compiles but requires more thorough testing),
- Delphi 11 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

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

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

Michał

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

Compiles and Works:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-win64(on Windows 11 Pro 22000.184),
- Delphi 2006,
- Delphi 2007(-ZBase64.pas),
- 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.2 Sp1,2,3 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

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

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

Michał

ZEOS 8.0.0 /trunk svn 7717,7719
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/
NEW: SaveToStream and LoadFromStream for ZMemTable(It's easy to use SaveToFile/LoadFromFile).

Compiles and Works:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC2-fpc-3.2.2-win64(on Windows 11 Pro 22000.184),
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11sp1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

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

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

Michał

Hi Jan,

Zeos8_svn_trunk_7733 Delphi 10.3.3-Win32

An entry in ZCore.dpk is missing:
ZExceptions in '..\..\src\core\ZExceptions.pas',

Compilation notes:
[dcc32 Warning] ZDbcFirebirdInterbase.pas(4565): W1024 Combining signed and unsigned types - widened both operands
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5254): H2164 Variable 'P' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5255): H2164 Variable 'Digits' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5256): H2164 Variable 'IsNegative' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5257): H2164 Variable 'C' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5315): H2164 Variable 'U' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5316): H2164 Variable 'P' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5317): H2164 Variable 'Digits' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5318): H2164 Variable 'IsNegative' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5538): H2164 Variable 'P' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5539): H2164 Variable 'W' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5540): H2164 Variable 'Digits' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5541): H2164 Variable 'IsNegative' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Warning] ZDbcODBCResultSet.pas(1915): W1021 Comparison always evaluates to False

Michał

Michal,

For the warnings please refer to this post.

I'll doublecheck the ZExceptions reference in all packages.

Hi Jan,

Continues remarks on svn 7733.
In svn 7733 Array BATCH-DML (e.g. for Firebird) stopped working, and it worked in svn7719.
Throws AV.
Test example in this thread:
viewtopic.php?f=50&t=146924

Michał

Hi aehimself,

I coped, as you can see.
But many don't.

Michał

Added ZExceptions.pas to all packages. I hope I did CBuilder and Lazarus correctly and made no typos anywhere.
Commit is included in the already open pull request.

Thanks for pointing this out!

ZEOS 8.0.0 /trunk svn 7740, 7741, 7742
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

To be able to use ZMemTable SaveToStream and LoadFrom Stream, you should enable in the zeos.inc file:
{$DEFINE ZMEMTABLE_ENABLE_STREAM_EXPORT_IMPORT} // line 97

Compiles and Works:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC2-fpc-3.2.2-win64(on Windows 11 Pro 22000.376),
- CT 7.7-Win32/Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11sp1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

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

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

1. ZMemTable SaveToStream / LoadFromStream problems with fields of the type
varchar(max), nvarchar(max), varbinary(max)- cloned from MS SQL- FreeTDS.
viewtopic.php?f=50&t=148059&start=105#p184659

2. Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

ZEOS 8.0.0 /trunk svn 7772
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.0(fpc 3.2.2)-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11sp1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

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

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

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

ZEOS 8.0.0 /trunk svn 7793
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.0(fpc 3.2.2)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus 2.2.0(fpc 3.2.2)-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 11sp1 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing)).

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

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

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał