[EMAIL PROTECTED] wrote: > hi all, > > it there a way to execute a SQL query generated by SELECT ? > for eg. : > select 'insert into plan (personid, curseid, statid) select > tbl.excelid, ' || id || ',status.id from tbl, status where > tbl.' || fldname || ' = status.name ;' from curses; >
A planned enhancement is to provide a built-in sqlite_exec() SQL function that evalutes its argument as SQL. The intended use is to implement stored procedures. But the function is not yet available. -- D. Richard Hipp <[EMAIL PROTECTED]>
