Zeoslib Portal

Posted: **19.07.2013, 22:10**

@EgonHugeist,

ADO - Access rather you have. It's called JET (Microsoft.Jet.OLEDB.4.0 provider) and should be in every Windows starting with XP.
If you looked to the example that I would be grateful.
I have no problem with the correct reading of the data but only with the save, particularly empty fields FILE and NOTE.

Michal

Posted: **19.07.2013, 22:50**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2524:
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

Posted: **20.07.2013, 23:13**

miab3,

i'll check the Access issue, but can't promisse anything..

Posted: **21.07.2013, 11:37**

@EgonHugeist,

It looks like the Access database *. mdb can only be read by ado-Jet.OLEDB/ACE.OLEDB.
But it's still good.

Michal

Posted: **21.07.2013, 11:50**

miab3,

had no time to check it yet. IIRC is you issue resolved?

Posted: **21.07.2013, 14:10**

@EgonHugeist,

I'm looking for.
Begins to explain a little.
INSERT (and UPDATE) from the dataset does not allow zero, null values and empty fields.
Attached example where you can see it better.

Michal

Posted: **21.07.2013, 15:10**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2528:
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

Posted: **24.07.2013, 12:51**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2547:
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).

(With the exception error of writing empty fields in ADO-JET-mdb)

Michal

Posted: **25.07.2013, 09:01**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2548:
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),

But for Delphi XE3 Trial:
[dcc32 Error] ZAbstractRODataset.pas(156): E2003 Undeclared identifier: 'TList<>'
[dcc32 Error] ZAbstractRODataset.pas(252): E2003 Undeclared identifier: 'TList<>'
[dcc32 Warning] ZAbstractRODataset.pas(446): W1000 Symbol 'Translate' is deprecated

(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.

(With the exception error of writing empty fields in ADO-JET-mdb)

Michal

Posted: **25.07.2013, 15:18**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2550:
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.

(With the exception error of writing empty and zero values in ADO-JET-mdb)

Michal

--------------
I recommend:
http://www.youtube.com/watch?v=JfZMTDcqKnQ

Posted: **26.07.2013, 10:40**

miab3,

(With the exception error of writing empty and zero values in ADO-JET-mdb)

Well i've allready played with your example. But i'm running into the same issues. I've installed an Access2007 and i'd tryed to play with some defaults of the MDB file like standartvalue = 'null' etc. but i fail too. If i change something on our ADO statment i get exceptions with MSSQL and Sysbase125. I didn't give up but sometimes i need to refresh my mind and going on with other things. That's a nasty thing, Michal. Access is horrable. Do you have the same trouble if you use the ADO components?

Posted: **26.07.2013, 12:57**

@EgonHugeist,

I also have problems with it.
Access mdb is not so important (well that is read by ZEOS).
There are libraries that somehow deal with it, even that of Delphi (called dbGo) or uses DAO fast KaDAO:
http://www.kadao.dir.bg/
http://www.kadao.dir.bg/download/kadao/kadao2011.zip

Where is DEFINE WITH_FTGUID in zeos.inc?

Michal

Posted: **26.07.2013, 13:23**

miab3,

There it is. Thank you for the hint. Did you start playing with the ftGUID? Have a look to: http://zeosbugs.firmos.at/view.php?id=164

The reason for it. I hadn't the time to update or insert something yet.

A test table, i made:

Code: Select all

CREATE TABLE Mantis164 (
  [CardID] varchar(30) NOT NULL,
  [CardTypeID] smallint NOT NULL,
  [PublishDate] datetime NOT NULL,
  [UserID] uniqueidentifier NOT NULL DEFAULT NEWID(),
  [AccountsID] uniqueidentifier NULL DEFAULT NEWSEQUENTIALID(),
  [Deposited] bit NOT NULL,
  [bBinary] binary(16) null,
  [bVarBinary] varbinary(16) null,
  [bImage] image null,
  CONSTRAINT [PK_CD_CardInfo] PRIMARY KEY CLUSTERED ([CardID], [CardTypeID])
)
ON [PRIMARY]

Realy annoying: There is technically no stable way to determine if the field is a TGUID or binary(16) except comparing the MetaInformations String of "TYPE_NAME"(which is useless because we've no extra GUID TZSQLType enum). The reason for the other bin fields of my example. If i could determine the type exacly on TZDBlibResultset.Open than i could add a extra property to the TZColumnInfo. Each appraoch fails there. I also added some more dbcol functions like dbColUType, dbcolInfo but the results for (var)binary(16) and uniqueidentifier are allways binary same. Pff MSSQL.
If i find the time i'll add a TCalculatedField to my tests and check what happens. If i find the time unforunally (;

But nothing prevents you to check how it works...

Posted: **26.07.2013, 13:48**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2559:
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.

(writing empty and zero values error in ADO-JET-mdb)

Michal

--------------
I recommend:
http://www.youtube.com/watch?v=fDFg9nRBSOM

Posted: **26.07.2013, 20:10**

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2560:
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.

(writing empty and zero values error in ADO-JET-mdb)

Michal

Zeoslib Portal

ZeosLib 7.1 testers-thread