Re: [htoolkit-users] testing hsql-sqlite3

[Bjorn B. <bri...@cs...>]

Duncan Coutts wrote:
> I've been trying the test HSQL-1.7/examples/Main.hs
>=20
> I've got it working for odbc, postgresql and mysql but not sqlite3.
>=20
> What goes wrong is that the test program can't extract integer fields.
> It's fine with varchar or string fields but not int ones.
>=20
> The error reported is:
>         The type of id field can't be converted to SqlText type
>=20
> Note that it works ok when we try to extract an int field as a Haskell
> String but not an int field as a Haskell Int (which is what the example
> program tries to do).
>=20
> I'll add the postgresql, mysql and odbc backends to gentoo and leave th=
e
> sqlite3 backend for the moment.
>=20
> If anyone has a patch to make the sqlite3 backend work with the example
> program then I'll be happy to include that into the gentoo package and
> add the sqlite3 backend too.

I have a patch for exactly this problem. For some reason I never=20
committed it. It is in CVS as of one minute ago. I have attached the=20
patch against a recent CVS version, in case you want to use the 1.7=20
release version.

/Bj=F6rn