PDA

View Full Version : Retrieve of the data from the database..?



gunturrohith
24th April 2015, 10:09
Hi i am trying to retrive the data from the database here is my program

Intially i am entering the mobile no in a line edit which i have named it as "searchedit" and then i am strong the data of line edit into a string and then i am trying to reterive the data from the database by the help mobile number which is present in the string and i have written the query as beolw

QString str1 = searchedit->text();
searchedit->setText(str1);

int ret;
QSqlQuery query;
query.exec("SELECT * FROM details WHERE mobile="(str1.data())"");

i am storing the data in a line edit into a string and then i am trying to retrive the data from the database which matches with the data present in the string,but it is showing an error " '"SELECT * FROM details WHERE mobile="' cannot be used as a function"

I need to retirve the details of the user by the help of their mobile numbers.

Please help to retrive the data from the data base i am using the sqlite database and my QT version is 4.7.4

Thanks in advance
Rohith.G

wysota
24th April 2015, 10:20
Duplicate of http://www.qtcentre.org/threads/62336-How-to-Retrive-data. Do not multipost please.

gunturrohith
24th April 2015, 11:10
Ok Sorry...!
Will never repeat this...:(