http://www.sqlite.org/lang.html
follow the link for
CREATE TRIGGER
----- Original Message -----
From: "Puneet Kishor" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, June 15, 2005 12:18 AM
Subject: [sqlite] stored procedures
searching on the 'net reveals that SQLite3 doesn't support storedprocs,
but they could be somewhat emulated via TRIGGERs. Is there a tutorial
on doing so? I want to wrap multiple, but logically single, SELECTs,
UPDATEs, INSERTs, and DELETEs into one db call.
preamble question -- is there a perf advantage to "creating" a
storedproc in SQLite? Does it pre-compile the storedproc? If there
isn't any perf advantage, I'd rather not even bother.
--
Puneet Kishor
