Zeoslib Portal

@Maib3,

does it mean it does not compile? Than i've small patch ready..

@EgonHugeist, @mdaems,

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

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Ticket54 error disappeared.

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R2926 with {$DEFINE WITH_ZSTRINGFIELDS}:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michael, looked at the "Type mismatch..." in FB?

Michal

@Miab3,

Michael, looked at the "Type mismatch..." in FB?

Sure. This is not solvable, yet. It would be possible by using the coming TZFields IMO. The type checks happen because of the internal TZSQLTypes. Zeos converts these values to integers which are faster than Floating values(i think) and it's alltime Zeos-Code. The current TField implementation moves the Mem to the FieldBuffers. If we would ignore the checks, than a Stack overflow could happen, like we had with the TCurrency-Fields. SizeOf(Integer) = 4, SizeOf(Single) too. But if it would be a double, currency, Extended value > Stack-overflow.

The TZFields (had no time to continue) wouldn't use a static buffer (no more mem-moves happen, just direct accassing and localizing the values on demand), they simply use the RowAccessor like a variant. If conversions are required, than they happen in Dbc-Layer. That's why i added a generic TZField descandant of TField. I have an idea how to make this code running optional (for each dataset) without a define. But i think i'll keep a define to exclude this code if someone is against it. That would would also avoid incompatibility issues.

@EgonHugeist

Michael,

I have an idea how to make this code running optional (for each dataset) without a define.

And can you also add new datasets leaving old.
To have two sets of datasets, Classic and New.
Then you will have more freedom to changes.

Michal

@EgonHugeist

Sorry to disturb just to give you some feedback, I tried with the latest alpha source and indeed mORMot tests showed improvements, did't have to do big changes, I decided to continue using the alpha an will be reporting any issues that appear

http://synopse.info/forum/viewtopic.php?pid=9007#p9007

Regards

@EgonHugeist

Michael,
Is the problem occurring(in many posts) "0 record (s) updated. Only one record should have been update"
is not due to very small differences in the data on the server side and the client side?
(When the key to update is all fields.)

Michal

@EgonHugeist, @mdaems,

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

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist, @mdaems,

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

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

(DXE2 - [DCC Hint] ZFastCode.pas(3111): H2164 Variable 'C' is declared but never used in 'IntToRaw')

Michal

@EgonHugeist,

Michael,
I do not know whether something can be useful, but in Delphi XE2-64 and higher there is no true type extended
http://blog.synopse.info/post/2011/09/1 ... XE2-64-bit
https://forums.embarcadero.com/thread.j ... adID=60551
But there is something like this:
http://cc.embarcadero.com/Item/28488

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R2945:
http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

([Pascal Warning] ZDbcMySqlResultSet.pas(570): W1036 Variable 'Buffer' might not have been initialized
[Pascal Hint] ZDbcMySqlResultSet.pas(561): H2164 Variable 'Len' is declared but never used in 'TZMySQLResultSet.GetLong')

Michal

@EgonHugeist, @mdaems,

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

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist,

Michael,
Zeos7.2_R2949
D2006 compiles
but
DXE2-32 not:
[DCC Error] ZSysUtils.pas(3041): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Error] ZSysUtils.pas(3042): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Error] ZSysUtils.pas(3043): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Fatal Error] ZEncoding.pas(942): F2063 Could not compile used unit 'ZSysUtils.pas'

Michal

@EgonHugeist, @mdaems,

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

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist, @mdaems,

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

- D2006, ([Pascal Error] ZAbstractRODataset.pas(3849): E2029 Expression expected but ',' found <-- ,,)
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal