ZeosLib 7.1 testers-thread

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 27.07.2013, 10:24

@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
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 27.07.2013, 23:01

@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
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 30.07.2013, 10:00

@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
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 30.07.2013, 14:13

@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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 31.07.2013, 22:32

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.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 31.07.2013, 23:15

@EgonHugeist,

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

Michal

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 31.07.2013, 23:54

@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
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 01.08.2013, 00:45

@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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 01.08.2013, 10:07

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?
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 01.08.2013, 10:46

@EgonHugeist,

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

Michal
You do not have the required permissions to view the files attached to this post.

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 01.08.2013, 15:37

@EgonHugeist,

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

Michal

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 02.08.2013, 08:56

@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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 02.08.2013, 10:48

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.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 02.08.2013, 11:15

@EgonHugeist,

You exclude stBytes:

line427: if not ( SQLType = stBytes ) then

so:

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

cut me a bigger BLOBS.

Michal

miab3
Zeos Test Team
Zeos Test Team
Posts: 943
Joined: 11.05.2012, 12:32
Location: Poland

Postby miab3 » 03.08.2013, 11:22

@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


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest