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 :-)
--
"Actuamos como si el lujo y el confort fueran lo m�s importante en la
vida, cuando todo lo que necesitamos para ser felices es algo que nos
haga sentir entusiasmo".
-- Albert Einstein
signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente
