BTW I wonder why SQLite doesn't support Stored Procedure.
Through Trigger it does already support some similar functionality.
Certainly, while writing trigger code it won't have been that much code to
write stored procedure code as well.....
That kind of puzzle me.. is there any rationale for the lack of stored
procedure?
----- 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
