Re: [sqlite] The execute command

2014-04-17 Thread aperi2007
Thx for hint. I see also the RSmith contribute. This is not only impossible in the current SQLite implementation, it is also inconceivable. By that I mean that the query output can be of any form, there is no way a prepare statement can know before-hand what the query would look like, it mig

Re: [sqlite] The execute command

2014-04-17 Thread RSmith
On 2014/04/17 20:43, aperi2007 wrote: Hi to all, There is in sqlite a command to run a query build at runtime ? Our use-case is a list of query build from a sql script and stored in a table. something like this: select EXECUTE([field_query]) from table1; where "table1" is the table and "fie

Re: [sqlite] The execute command

2014-04-17 Thread Richard Hipp
On Thu, Apr 17, 2014 at 2:43 PM, aperi2007 wrote: > Hi to all, > > There is in sqlite a command to run a query build at runtime ? > Not built-in. But you can add your own. See http://www.sqlite.org/src/artifact/d3013ce36f19ac72?ln=289-319 for an example function that does this that we use for

[sqlite] The execute command

2014-04-17 Thread aperi2007
Hi to all, There is in sqlite a command to run a query build at runtime ? Our use-case is a list of query build from a sql script and stored in a table. something like this: select EXECUTE([field_query]) from table1; where "table1" is the table and "field1" is the field where the builded q