Re: [sqlite] how to get the Trigger's Raise err in Application

[Nataraj S Narayan]

Hi

The problem is solved after a recompile of QT with  options:-

-system-sqlite  -v -I/<path-to>/sqlite-3.6.17 -L/<path-to>/sqlite-3.6.17/.libs ,

whereas previously i had compiled sqlite as plugin.

Now the trigger message is caught promptly by :-

 sqlite3 *handle = *static_cast<sqlite3 **>(v.data());
            if (handle != 0)
            { // check that it is not NULL
                qDebug("Error: %s", sqlite3_errmsg(handle));
                QMessageBox::about(0,"Trigger",sqlite3_errmsg(handle));
            }

regards

Nataraj

On Fri, Oct 30, 2009 at 6:50 PM, greensparker
<balamurugan.c...@gmail.com> wrote:
>
> Jan,
>    my system dont have any file named llibsqlite , in my filesystem
> but i have
>   /usr/lib/libsqlite.so
>   /usr/lib/libsqlite.so.0
>   /usr/lib/libsqlite.so.0.8.6
>   /usr/lib/libsqlite3.so
>   /usr/lib/libsqlite3.so.0.8.6
>
> my pro file have
>
> LIBS += /usr/lib/libsqlite.so
> INCLUDE +=/usr/include
> QT += sql
> HEADERS += mainMenu.h
> SOURCES += main.cpp \
>    mainMenu.cpp
>
> And getting the following err
> mainMenu.o: In function `mainMenu::createMainMenu()':
> /home/bala/test1/mainMenu.cpp:69: undefined reference to `sqlite3_errmsg'
> collect2: ld returned 1 exit status
> make: *** [test] Error 1
>
>
> jan-118 wrote:
>>
>> afaik on unix you need this
>>
>> LIBS += -L/usr/lib -llibsqlite
>>
>>
>>
>> greensparker schrieb:
>>> Im in Debian Linux.,
>>> This is my pro file
>>>
>>> QT += sql
>>> LIBS +=/usr/lib/libsqlite.so
>>> INCLUDE +=/usr/include
>>> HEADERS += mainMenu.h
>>> SOURCES += main.cpp \
>>>     mainMenu.cpp
>>>
>>> headers in my mainMenu.cpp file
>>>
>>> #include "mainMenu.h"
>>> #include <QSqlDriver>
>>> #include "DBConnection.h"
>>> #include <sqlite3.h>               // path = usr/local/include/sqlite3.h
>>>
>>> same err im getting
>>> :69: undefined reference to `sqlite3_errmsg'
>>> collect2: ld returned 1 exit status
>>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
> --
> View this message in context: 
> http://old.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26129984.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users