Re: [sqlite] how to load custom function from QT

2010-01-25 Thread Michal Seliga
i somehow skipped one message in thread and as result i posted you what you already knew and wrote, sorry no more ideas from me On 25. 1. 2010 12:27, greensparker wrote: > > Thnks michel for ur reply. > yes thats the way. i also tried using the HANDLE. but the query failed in > int b = sqli

Re: [sqlite] how to load custom function from QT

2010-01-25 Thread greensparker
Thnks michel for ur reply. yes thats the way. i also tried using the HANDLE. but the query failed in int b = sqlite3_load_extension(handle,zFilename,0,0); my program hangs when i put 0,0 to the third and forth parameter in sqlite3_load_extension funciton. any tips? Thnks Bala -- View this message

Re: [sqlite] how to load custom function from QT

2010-01-25 Thread Michal Seliga
i did it, and solution is not nice in general, qt doesn't export any of sqlitefunctions in its sqlite driver. so you have to add sqlite to your project. you can find version of sqlite used in qt in its sources (qt/src/3rdparty/sqlite) or if its set to use dynamically sqlite installed in system you

Re: [sqlite] how to load custom function from QT

2010-01-25 Thread greensparker
can somebody help me to solve this? Bala -- View this message in context: http://old.nabble.com/how-to-load-custom-function-from-QT-tp27292725p27304796.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite

Re: [sqlite] how to load custom function from QT

2010-01-24 Thread greensparker
I have tried "select load_extension('mylib.so')" through QSQLQUERY. But it fails, with following error. unknown function name LOAD_EXTENSION and for the API from QT i hav included sqlite3ext.h and following code QSqlQuery qmenu; QVariant v = qMenu.driver()->handle(); if (v.isValid() &&

Re: [sqlite] how to load custom function from QT

2010-01-24 Thread Kees Nuyt
On Sat, 23 Jan 2010 22:57:24 -0800 (PST), greensparker 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 worki

[sqlite] how to load custom function from QT

2010-01-23 Thread greensparker
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