[sqlite] ODBC driver for C error "only one SQL statement allowed"

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

[sqlite] Recall: ODBC driver C source file includes a header which was not shipped

Hi, I realize I have to recall my question. It was my fascination about the "amalgamation" version of sqlite3 that made me think that even sqlite3odbc.c was an "amalgamation". I apologize, should have read README before complaining. Martin Abshagen

[sqlite] ODBC driver C source file includes a header which was not shipped

Hi, am trying to use the Sqlite3 ODBC driver for C, provided by Christian Werner (http://www.ch-werner.de/sqliteodbc/, product sqliteodbc-0.77-1.src.rpm). If _WIN32 is defined, sqlite3odbc.c includes a "resource3.h" header file, which is not shipped with the version. How could I work around or

[sqlite] Does or will Sqlite provide a DUMP mechanism?

Hello all, I am new to Sqlite and I would like to backup Sqlite databases at runtime. Appearently Sqlite does not (yet?) provide a functionality such as mysqlhotcopy. My questions are: Can a backup mechanism be implemented by means of the current Sqlite-API? And if not so: Does anybody plan to