> -----Original Message----- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 5:57 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > Williams, Ken wrote: > > > > Hmm - all of those functions seem to depend only on their > argument input, > > making no external calls to the database. How would I > implement, for > > example, a stored procedure that performs several > inserts/selects on several > > database tables? > > > > I tried a little experiment with the Perl interface (which uses the > > sqlite_create_function() call under the hood), and the > function I created > > just hangs when it's called. Is SQLite not re-entrant in > this way, or is > > this a peculiarity of the Perl interface? My code is below. > > > > That capability was added on 2004-Jan-07. See check-in [1166]. > > I have no idea whether or not Perl supports the new capability.
Hi, I just downloaded sqlite-2.8.11, ran the DBD::SQLite getsqlite.pl script, and tried my test again. It worked. Matt, it would be great if you would issue another release of DBD::SQLite with an updated sqlite distribution. These latest changes make it possible to write some rather effective stored procedures in Perl. -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
