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

Attachment: signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente

Reply via email to