2010/7/27 Roger Binns <rog...@rogerbinns.com>
> I had also considered doing one. The approach I would have taken is using
> virtual tables where you could supply the pragma statement as the first
> parameter to the table. The difficulty is in knowing what column names
> should be returned as I really don't want to hard code them.
>
>
Why difficulty? I did add example:
http://sqlite.mobigroup.ru/artifact/373384470e6b2e00fc503e674def057986ae00b4
.load ./libsqlitepragmacols.so
select pragma_cols('pragma database_list');
seq, name, file
I note you ended up hard coding column names and "polluting" both the
> temporary database and function list :-)
>
It's more simple than to discuss about :-)
> I'd be a little nervous about using SQLITE_STATIC instead of
> SQLITE_TRANSIENT.
You are right, thanks.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
