Sqlite data base

[ChrisW67]

how to solve this problem please help me

What problem?

Did you look at the return value from QSqlQuery::exec()?
Did that indicate that there was a problem?

Did you read the QSqlError docs? They tell you what the error number -1 might mean.

You really need to help yourself more.

[sabbu]

QSqlError(1, "Unable to execute statement", "no such table: CityType") this error is find how to solve this problem please help me

Thanks

[stampede]

"no such table: CityType"
I think this sentence is clear enough.

[ChrisW67]

I told you the likely problem here. You don't have a table called CityType, so you cannot query it. Pretty simple really. If you don't understand why you don't have a table called CityType given the database creation code I referenced then there is little we can do to help.

From your earlier post http://www.qtcentre.org/threads/41747-Sqlite-data-base

QSqlQuery query;
query.exec("create table person (Id int primary key,name varchar(20), typeid int)");
query.exec("insert into person values(1, 'Delhi',101)");
query.exec("insert into person values(2, 'Gurgaon',102)");
query.exec("insert into person values(3, 'Noida',103)");
query.exec("insert into person values(4, 'Gaziabad',104)");
query.exec("insert into person values(5, 'faridabad',105)");
//! [Set up the main table]

QSqlQuery query;
query.exec("create table person (Id int primary key,name varchar(20), typeid int)");
query.exec("insert into person values(1, 'Delhi',101)");
query.exec("insert into person values(2, 'Gurgaon',102)");
query.exec("insert into person values(3, 'Noida',103)");
query.exec("insert into person values(4, 'Gaziabad',104)");
query.exec("insert into person values(5, 'faridabad',105)");
//! [Set up the main table]

To copy to clipboard, switch view to plain text mode 

I am more confused how you go from "My query executed" with no error in your posts 9 and 10 of this thread, to this this very specific and informative error message. Are you working through this thing in any sort of methodical matter, or are you thrashing around in the hope that eventually you will get lucky, or someone will succumb and fix your code and post a complete implementation? The first approach will give you an understanding, the second and third will leave you with similar problems in a few days/months/years time and no idea how to deal with them.

Take a step back from the code, look at what you are trying to achieve and write down in English/your native tongue the broad things you need to achieve to get there. Then break each down into smaller, more specific things, until each item is a manageable, small bit of C++/SQL/shell script code or manual activity. Then work through each in turn, making sure it works before moving on.

[DanH]

Either you're command of English is far worse than it appears, or you are not cut out to be a programmer. I'd strongly suggest that you consider other occupations.