[sqlite] how to load custom function from QT

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

[sqlite] sqlite on opensolaris with bogofilter

I am using sqlite 3.6.21 with bogofilter 1.2.1 on opensolaris 5.11 snv_111b When I run bogoutil -r sqllite.db it returns -NaN Any ideas? Is it a sqlite problem or bogofilter problem? Thanks for any tips. I tried compiling sqlite with -DSQLITE_HAVE_ISNAN

[sqlite] error with authorizer, onecolumn and TCL

The following sequence gives an incorrect result value: (ramsan) package require sqlite3 3.6.22 (ramsan) 2 % sqlite3 db :memory: (ramsan) 3 % db authorizer myauth (ramsan) 4 % proc myauth { cmd args } { return SQLITE_OK } (ramsan) 6 % db eval { create table t(a,b) } (ramsan) 7 % db onecolumn {

Re: [sqlite] famous "constraint failed" error

Jan Bilek wrote: > ... is there any way how to detect which constraint has failed? http://www.sqlite.org/src/tktview?name=23b2128201 Roger ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] famous "constraint failed" error

What else do you need to know? BTW... is there any way how to detect which constraint has failed? Jan Pavel Ivanov wrote: >> But why it only happens when any concurrent select query is in progress? >> > > Probably you don't tell us all necessary information about your set up > (or maybe

Re: [sqlite] Is there size limit for tables?

On Sat, Jan 23, 2010 at 10:39 AM, Luigi__ wrote: > Okay. I've got a table. I insert data in it via an INSERT INTO query. > > I can insert as many rows as I want. But it seems that if my table gets past > a certain size, when trying to INSERT data in it, I'll just get a

[sqlite] Is there size limit for tables?

Okay. I've got a table. I insert data in it via an INSERT INTO query. I can insert as many rows as I want. But it seems that if my table gets past a certain size, when trying to INSERT data in it, I'll just get a completely blank page. No error message. I absolutely hate silent failing. So

[sqlite] How to detect SQLITE_ENABLE_FTS3_PARENTHESIS support?

Suppose that I'm using an SQLite database via a non-C interface (such as Perl, Python, PHP, etc.) which is running a version of SQLite that I have no control over and I would like to determine whether or not SQLITE_ENABLE_FTS3_PARENTHESIS support is enabled. How can I do this? (It's easy