Re: [sqlite] how to get the Trigger's Raise err in Application
Hi The problem is solved after a recompile of QT with options:- -system-sqlite -v -I//sqlite-3.6.17 -L//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(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 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 >>> #include "DBConnection.h" >>> #include// 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
Re: [sqlite] how to get the Trigger's Raise err in Application
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 >> #include "DBConnection.h" >> #include// 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
Re: [sqlite] how to get the Trigger's Raise err in Application
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 > #include "DBConnection.h" > #include// 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
Re: [sqlite] how to get the Trigger's Raise err in Application
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 #include "DBConnection.h" #include// path = usr/local/include/sqlite3.h same err im getting :69: undefined reference to `sqlite3_errmsg' collect2: ld returned 1 exit status -- View this message in context: http://old.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26129536.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
Re: [sqlite] how to get the Trigger's Raise err in Application
If your are on windows try this in your .pro file: win32:LIBS += [yourpath]\libsqlite.lib win32:INCLUDEPATH += [yourpath]\include Check Qt docs on qmake for unix. Jan greensparker schrieb: > jan Thnks fr ur support. I have included sqlite3.h. > But getting the following err. > > 69: undefined reference to`sqlite3_errmsg' > > :-1: error: collect2: ld returned 1 exit status > > How to resolve? > > Thnks > Bala ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] how to get the Trigger's Raise err in Application
jan Thnks fr ur support. I have included sqlite3.h. But getting the following err. 69: undefined reference to`sqlite3_errmsg' :-1: error: collect2: ld returned 1 exit status How to resolve? Thnks Bala -- View this message in context: http://old.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26126588.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
Re: [sqlite] how to get the Trigger's Raise err in Application
sqlite3.h greensparker schrieb: > what are the headers i need to add in QT , to get sqlite3 *handle syntax and > sqlite3_errmsg working ?? > > > jan-118 wrote: >> greensparker schrieb: >>> i want the trigger's raise error in QT call. >> Try this in Qt: >> >> QString msg; >> QVariant v = QSqlDatabase::database().driver()->handle(); >> sqlite3 *handle = *static_cast(v.data()); >> if (handle != 0) >> msg =sqlite3_errmsg(handle); >> >> >> Jan >> ___ >> 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
Re: [sqlite] how to get the Trigger's Raise err in Application
what are the headers i need to add in QT , to get sqlite3 *handle syntax and sqlite3_errmsg working ?? jan-118 wrote: > > greensparker schrieb: >> i want the trigger's raise error in QT call. > > Try this in Qt: > > QString msg; > QVariant v = QSqlDatabase::database().driver()->handle(); > sqlite3 *handle = *static_cast(v.data()); > if (handle != 0) > msg =sqlite3_errmsg(handle); > > > Jan > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26112586.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
Re: [sqlite] how to get the Trigger's Raise err in Application
greensparker schrieb: > i want the trigger's raise error in QT call. Try this in Qt: QString msg; QVariant v = QSqlDatabase::database().driver()->handle(); sqlite3 *handle = *static_cast(v.data()); if (handle != 0) msg =sqlite3_errmsg(handle); Jan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] how to get the Trigger's Raise err in Application
thnks igor , the return type of q.exe is bool bool QSqlQuery::exec ( const QString & query ) q.lasterror() returned QSqlError(19, "Unable to fetch row", "constraint failed") I dont know how to track this. i want the trigger's raise error in QT call. Thnks Bala Igor Tandetnik wrote: > > greensparker wrote: >> im using QT4.5 and sqlite3 >> >> im using BEFORE INSERT TRIGGER for validation purpose >> [is it good idea to put validation on before_insert_trigger???] > > You could have a CHECK constraint in the table definition instead. > >> IN QT im inserting as >> q.exec("insert into PARAM_DETAILS(PARAM_CODE,PARAM_VALUE) >> values(12,'9789')"); >> >> when i execute this insert code in sqlite3 cmd prompt , i got the error. >> >> but how to capture this err in APPLICAITON? > > Check the return value of QSqlQuery::exec, see also QSqlQuery::lastError > > Igor Tandetnik > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26093874.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
Re: [sqlite] how to get the Trigger's Raise err in Application
greensparker wrote: > im using QT4.5 and sqlite3 > > im using BEFORE INSERT TRIGGER for validation purpose > [is it good idea to put validation on before_insert_trigger???] You could have a CHECK constraint in the table definition instead. > IN QT im inserting as > q.exec("insert into PARAM_DETAILS(PARAM_CODE,PARAM_VALUE) > values(12,'9789')"); > > when i execute this insert code in sqlite3 cmd prompt , i got the error. > > but how to capture this err in APPLICAITON? Check the return value of QSqlQuery::exec, see also QSqlQuery::lastError Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] how to get the Trigger's Raise err in Application
hi, im using QT4.5 and sqlite3 im using BEFORE INSERT TRIGGER for validation purpose [is it good idea to put validation on before_insert_trigger???] im generating err , when the validation fails like create TRIGGER MobileValid BEFORE INSERT on PARAM_DETAILS when new.PARAM_CODE=12 BEGIN SELECT RAISE(ABORT,'First Digit Should Be 9') where substr(new.PARAM_VALUE,1,1)<>'9' ; SELECT RAISE(ABORT,'Length Should Be 10') where length(new.PARAM_VALUE)<>10 ; END; This is working fine. My question is , how to get this TRIGGER RAISE ERROR in QT application? IN QT im inserting as q.exec("insert into PARAM_DETAILS(PARAM_CODE,PARAM_VALUE) values(12,'9789')"); when i execute this insert code in sqlite3 cmd prompt , i got the error. but how to capture this err in APPLICAITON? pls guide me? bala -- View this message in context: http://www.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26091341.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