Abshagen, Martin RD-AS2 wrote:
Hi, sqlite-users,
am evaluating Sqlite ODBC driver for C (current sqliteodbc.exe by Ch. Werner,
http://www.ch-werner.de/sqliteodbc/). After defining successfully two tables "mytable"
and "mysequence", I tried to define a trigger by means of
"CREATE TRIGGER trg BEFORE INSERT ON mytable FOR EACH ROW BEGIN INSERT INTO
mysequence VALUES(0); END"
This worked fine with sqlite3.c, when passed to sqlite3_exec(), but gave rise
to an error message with sqlite3odbc.c , when passed to SQLExecDirect(). The
message was :
"only one SQL statement allowed".
Is there a special SQL syntax required for sqlite3odbc?
Are there any (further) restrictions for triggers?
Or is it a bug?
Best regards
Martin Abshagen
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
It's clearly a bug / limitation in the ODBC wrapper - it obviously
parses the SQL you're passing it and doesn't understand trigger syntax,
thus bailing out. You might want to contact the developer and ask
whether there are plans to update the wrapper.
--
Multumesc,
Mihai Limbasan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
