On 5/17/05, Svetlik Slavomir <[EMAIL PROTECTED]> wrote: > Hi, I am new in this forum, but not in SQLite3. I successfully used > SQLite3.dll with Rapid-Q (very good programming language - clone of > Q-Basic), basic commands like CREATE, INSERT, SELECT, UPDATE etc. works > fine, thanks! > My newbie question: If I create two tables (parent and child), I know > set relationship between this tables only by temporarely commands SELECT > and JOIN (when I read data) - this way I used to this time. But - is > there any other solution (inside SQLite), how to SET this relationship > PERMANENT and than it works automatically (for example by deleting > parent record, where are deleted child records too (like in MS Access)) > or in future GET this relationship for better understanding my or > strange tables?
Sorry, there's no referential integrity enforcement in Sqlite either.
