[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--