Re: creating tables needed for a query on-demand

Roger Binns wrote:
> What I meant is that the schema has to be correct - ie tables and
> columns have to exist.
>
>   
ah, right. yes, I got around that by doing all of the table creation up 
front - that part runs quick enough.
> Then why are you using SQL at all?  Why not just present your data?
>   
while most users won't be looking at SQL at all, I still want to provide 
a flexible interface to the data that allows advanced users to invent 
their own queries. besides, even if nobody but me looked at the SQL 
stuff, this is a much simpler way of implementing it than the 
alternative. ;)
> Ok, it really sounds like you should be using virtual tables at which
> point none of this is an issue!
>   

I cannot but wholeheartedly agree. ;)