Re: Enabling the foreign key support in Sliqte3

[Petite Abeille <petite.abeille@...>]

On Mar 13, 2011, at 7:24 PM, Luciano de Souza wrote:

> For these reasons, I also believe the problem is in Luasql-sqlite3 and not in Sqlite3.

Not sure if this is the same issue, but you might want to update LuaSQL's sqlite3 driver to use sqlite3_prepare_v2 instead of the old sqlite3_prepare. 

http://www.sqlite.org/capi3ref.html#sqlite3_prepare

In ls_sqlite3.c, line 350:

	res = sqlite3_prepare_v2(conn->sql_conn, statement, -1, &vm, &tail);

Note the '_v2' suffix to 'sqlite3_prepare'.

FWIW, I'm happily using LuaSQL and SQLite 3.7.5 with foreign constraints.