Zeoslib Portal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3545 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success- new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).[/b]

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.643 2014-12-12 20:52:33 from:
http://synopse.info/fossil/info/dec5dae ... 56e998c1a5
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3558 (and Revision 3564) :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success- new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.643 2014-12-12 20:52:33 from:
http://synopse.info/fossil/info/dec5dae ... 56e998c1a5
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta r31474.

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3574 (and r3578) :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success- new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.664 2014-12-30 18:49:47 from:
http://synopse.info/fossil/info/93d421a ... 13a1b70065
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta r31527.

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3590:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success- new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20testing) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.680 2015-01-06 10:37:09 from:
http://synopse.info/fossil/info/266dbf2 ... d5e9bd01c7
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta r31530.

ADD 2015-01-09:
- Lazarus 32/64(fpc 3.1.1) on Windows7-64(CodeTyphon ver 5.20final) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows.

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3597:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20testing) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 32/64(fpc 3.1.1) on Windows7-64(CodeTyphon ver 5.20final) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows.
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.696 2015-01-11 08:52:37 from:
http://synopse.info/fossil/info/9ce9f10 ... c18a5cf9e5
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta r31530.

Michal

@EgonHugeist, @mdaems, All

Warning!!!
FetchRow(>0) absolute limits the data.
Change in ZAbstractRODataset.pas r3594.

Michal

miab3 wrote:@EgonHugeist, @mdaems, All

Warning!!!
FetchRow(>0) absolute limits the data.
Change in ZAbstractRODataset.pas r3594.

Michal

isn't it pupose of this property or am i wriong? This property strickly limits cached/retrieved data to a user specified limit.
Do you have problems now? Except the Fetched data is limted to the property "FetchRow" ??

@EgonHugeist,

FetchRow so far limited the first portion of the data in the dataset but allowed to fetch next portions of data.
Now(after r3594) limits the completely amount that can be retrieved.

Michal

Well ...
As far as i understand you are you starting from the premisse if FetchRow=200 than 200 rows are cached. Scrolling to end, fetch next 200 or something similar. Im i right, Michal?

If soo ... I do not see where this case is handled. Nowhere, sorry.

What do you think? Rollback?

@EgonHugeist,

EgonHugeist wrote:Well ...
As far as i understand you are you starting from the premisse if FetchRow=200 than 200 rows are cached. Scrolling to end, fetch next 200 or something similar. Im i right, Michal?

If soo ... I do not see where this case is handled. Nowhere, sorry.

What do you think? Rollback?

Yes approximately.
I think this should be withdrawn (too high incompatibility).

AnyDAC has the:
FetchOptions.RecsMax
FetchOptions.RowsetSize <- corresponds FetchRow in ZEOS
and a few other FetchOptions(it is worth to see it).

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3599:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20testing) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 32/64(fpc 3.1.1) on Windows7-64(CodeTyphon ver 5.20final) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows.
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.700 2015-01-13 10:55:09 from:
http://synopse.info/fossil/info/a5ea4af ... 728d1402cb
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, Firebird 3.0 Beta r31530.

Restored old functionality FetchRow.

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3605:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.20testing) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 32/64(fpc 3.1.1) on Windows7-64(CodeTyphon ver 5.20final) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows.
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.717 2015-01-15 19:31:17 from:
http://synopse.info/fossil/info/8927eee ... d571b191ab
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, Firebird 3.0 Beta r31530.

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3606:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/

Need to change in ZPlainMySqlConstants.pas (for C++)
line542: signed: Boolean; //signed ordinals or not? Just for reading!
maybe Signed: ???

Michal

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3609:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 3.1.1) on Windows7-64(CodeTyphon ver 5.20) - CodeTyphon ver 5.20 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success - new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).

Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.739 2015-01-19 21:55:10 from:
http://synopse.info/fossil/info/b87959a ... 528c50d731
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.4, MySQL 5.5.40, MariaDB 5.5.40, MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, Firebird 3.0 Beta r31557.

Michal

Hi!
I have a problem with 7.2 from svn:
using a zconnection with autocommit = true and isolationlevel = tinone
I try to delete an active record via
starttransaction
zquery.execute('Delete x from y where z')
commit
This works with 7.1.4 but not with 7.2

What has changed?
Or am I doing something wrong?

Dieter