I use triggers to do this. Quoting Jay Sprenkle <[EMAIL PROTECTED]>:
> 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. >
