On Sat, 23 Jan 2010 22:57:24 -0800 (PST), greensparker
<[email protected]> wrote:
>
>hi, im using DEBIAN,QT4.5.2
> I have custom functions in sqlite,like ascii,ceil,floor etc.
>lib name is myfunciton.so.
>i have tested manually in sqlite3 command line by using, select
>load_extension('myfunction.so') .
>Its working well. my question is ,how can i automate this with QT.
>i want to use CEIL function from QT.
>like,
>QSqlquery q=("select ceil(5.2)");
>
>pls guide me
>
>Bala
load_extension() is a SQL function, so you could try to do
the same from QT.
: QSqlquery q=("select load_extension('/path/to/myfunctions.so')");
: QSqlquery q=("select ceil(5.2)");
If that doesn't work, try to find the equivalent for
sqlite3_load_extension() in the QSql API.
http://www.sqlite.org/lang_corefunc.html#load_extension
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users