>Would it be useful to have recursive DELETE triggers
>even without recursive INSERT or UPDATE triggers?
Recursive DELETE triggers would certainly be usefull and have in fact already
been asked for on this list occasionally. They would allow to move referential
integrity of hierarchical data
>
> Thoughts? Would making recursive triggers an error rather
> than just silently ignoring them break anybody's code?
even if it does, it should. otherwise, people may assume that the
functionality exists,and rely on it.
> I'm also looking at making DELETE triggers recursive. I can
> do
"Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> Cascading triggers are supported [in SQLite], recursive triggers are not.
> That is, if you have an insert trigger on table A which, say, inserts
> into table B, and there's an insert trigger on table B, it will run. But
> if this latter trigger
See the email of Igor Tandetnik from 18-Dec-2005:
"Vishal Kashyap" wrote
> Is their any way we can write simple stored procedures or functions
> in sqlite. If yes please do guide me I need this functionality in one
> of my open source project.
Not in the usual sense, meaning some language that
Hi,
Can you tell me how to create a stored procedure
in an sqlite3 database and use the same in a trigger? Please provide an example
(as complete as possible). In the stored procedure I need to execute few
queries on some tables. Can you tell me how to do that also?
Any help is deeply
5 matches
Mail list logo