yes there is. embed the sql in a table then execute it as needed passing the appropriate parms.
Woody --- On Fri, 7/25/08, Robert Simpson <[EMAIL PROTECTED]> wrote: From: Robert Simpson <[EMAIL PROTECTED]> Subject: Re: [sqlite] Return a rowset from function? To: "'General Discussion of SQLite Database'" <sqlite-users@sqlite.org> Date: Friday, July 25, 2008, 2:10 PM No, but that would be wicked cool and bring stored procs a lot closer to reality. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alexey Pechnikov Sent: Friday, July 25, 2008 11:08 AM To: General Discussion of SQLite Database Subject: [sqlite] Return a rowset from function? Hello! There is any way to create 'table functions', which are functions that return a rowset and are used in place of a table to generate rows? Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users