[Mono-list] Problems with Sqlite

tapia tapia@eitig.com
Fri, 06 Feb 2004 15:42:01 +0100


--=-qjubUwiu5bDyqzlbmOyW
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: quoted-printable

Hi.

I'm working in a project using Mono.Data.SqliteClient, and I have a
little problem. I have a SQL sentence, and if I execute it via the
sqlite commandline interface it works fine, but if I execute it via
Mono, the runtime show me this error:

Unhandled Exception: System.ApplicationException: Sqlite error near
"'prueba": syntax error

The SQL sentence is here:

INSERT INTO music (file, title, length, artist, album, year, track,
comment, bitrate, frequency, mode) VALUES
('/home/tapia/mono/mcatalog/plugins/prueba.mp3','prueba',170,'Henri
Mancini','Best Of...','',1,'',163,48000,'Stereo')

And the table is here:

CREATE TABLE music (
	file STRING PRIMARY KEY NOT NULL,
	title STRING,
	length INTEGER,
	artist STRING,
	album STRING,
	year STRING,
	track INTEGER,
	comment STRING,
	bitrate INTEGER,
	frequency INTEGER,
	mode STRING)

Is there a Mono.Data.SqliteClient bug, or am I doing something wrong?

Thank you :-)


--=20
"Actuamos como si el lujo y el confort fueran lo m=E1s importante en la
vida, cuando todo lo que necesitamos para ser felices es algo que nos
haga sentir entusiasmo".
-- Albert Einstein

--=-qjubUwiu5bDyqzlbmOyW
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada
	digitalmente

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBAI6e4UB+wbKFFlkARAnEuAKCwNrfNgnQvKcVNZCmEVn6qqfTwLwCgrLFd
5iIDkqAiWNWUDk/wvt5fIPk=
=tpc6
-----END PGP SIGNATURE-----

--=-qjubUwiu5bDyqzlbmOyW--