ZeosLib 7.1 testers-thread

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2564:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2569:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2584:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist, @mdaems,

It looks like the same error I mentioned.
Ado can not save empty, null and zero values.
http://zeos.firmos.at/viewtopic.php?p=17685#17685

Michal

[EgonHugeist]

miab3,

Patch done R2596 \testing-7.1.
Now we can update null values and we can handle defaults 'NULL' but i've still no idea how to insert a row with your example! Now i got another exception: "Operation must use...." Hmpf. I checked the query and everything is fine. This fixes a loads of test-fails i had.
My patch solves also your ABTEST storedproc issue + ADO. Do you remember? The params didn't refresh. But i haven't tested all available types for the parameters.

[miab3]

@EgonHugeist,

It starts to work but I think there is a problem with the float, double Access type.

Michal

[miab3]

@EgonHugeist,

I think it is explained. 'Float' is faulty field name in Access.
However, the problem is probably with the type of Currency/Money.

Michal

[miab3]

@EgonHugeist,

Now I see that this is rather a problem with the default values and Autonumber(the values set by a dbengine)​​in Access.
But that the basic functionality of the insert/update work.
Thanks.

Michal

[EgonHugeist]

miab3,

Now I see that this is rather a problem with the default values and Autonumber(the values set by a dbengine)​​in Access.

Is this case included in your file?

[miab3]

@EgonHugeist,

ZTable has problems in ZQuery can handle them.
I attach a recent example.

Michal

[miab3]

@EgonHugeist,

Why you do not set P.Size: = S for stBytes?
ZDbcAdoStatement.pas Line: 438

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2600:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Empty, default values and Autonumber in ADO(jet) works.
In my opinion in line:438 ZDbcAdoStatement.pas after 'else'
should be:

Code: Select all

    begin
        P.Type_ := T;
        P.Size := S;
        P.Value := V;
      end;

Michal

[EgonHugeist]

Empty, default values and Autonumber in ADO(jet) works.
In my opinion in line:438 ZDbcAdoStatement.pas after 'else'
should be:
Code: [Erweitern] [mehr anzeigen] [Verkleinern] [Alles ausw?hlen]
begin
P.Type_ := T;
P.Size := S;
P.Value := V;
end;

Disagree. You don't know how ADO behaves here.

Current code:

Code: Select all

      if not VarIsNull(V) then //align new size and type
      begin
        P.Type_ := T;
        P.Size := S;
      end;
      if VarIsClear(P.Value) or (P.Value <> V) then //Check if Param is cleared, unasigned or different
        P.Value := V;

This means updating the variant only if unassigned or invalid (VarIsClear) or if the Value did change. So why this?

In several circumstances P.Value is assigned like INOUT values of the StoredProcedures. You propose to override the vaules allways. ADO internally always compares OLD_Value against New_value and then the updates happen. Your proposal would update columns which shouldn't be changed.

[miab3]

@EgonHugeist,

You exclude stBytes:

line427: if not ( SQLType = stBytes ) then

so:

line437: else
line438: P.Value := V;

cut me a bigger BLOBS.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2603:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal