[Gambas-user] Issue 193 in gambas: SQLite Foreign Key code not allowed

[gambas at ...2524...]

Comment #2 on issue 193 by john.aar... at ...626...: SQLite Foreign Key code  
not allowed
http://code.google.com/p/gambas/issues/detail?id=193

This is is a newbie question but is there no support for Foreign Keys in  
gb.sqlite3 component?

I didn't realise that a table could be created using the Exec() method.  
I've done that (including the Foreign Key clause) and it worked!

PS Unfortunately, sqlite3 does not allow "ALTER TABLE ADD CONSTRAINT" to  
add the foreign key: I've tried it & the statement was rejected with a  
syntax error. Further confirmation can be found on:
http://stackoverflow.com/questions/1884818/how-do-i-add-a-foreign-key-to-an-existing-sqlite-3-6-21-table