Re: Enabling the foreign key support in Sliqte3

[Bob Chapman <chapmanrec@...>]

On Sat, Mar 12, 2011 at 6:20 PM, Luciano de Souza <luchyanus@gmail.com> wrote:
> Hi all,
>
> I want to use foreign keys in Sqlite3. I am using the modules available in
> Lua for Windows and I downloaded the DLL and the commandline tool for
> Sqlite3.

>
> Does someone has an idea why I can't use foreign keys?
>

Does your example work for the command line tool? If so, this might be
the problem:

Lua 5.1.4  Copyright (C) 1994-2008 Lua.org, PUC-Rio
> require "luasql.sqlite3"
> env = luasql.sqlite3()
> con = env:connect("")
> cur = con:execute("select sqlite_version()")
> print(cur:fetch())
3.3.17   <====

[Run using the Lua for Windows package]

--