[solved]qt sql insert statement system not working

[gayu]

Are u using QMYSQL. Are u working in qt4

[developer]

@gaya i am using QSQlITE yes i am working in qt4

[broadpeak]

Try this codesnippet:

@

void YourClass::init()
{
//...
initDB("../../../db/mydb.db3"); // of course your db path goes here
//...
}

void YourClass::initDB(QString dbPath)
{
vc2DB = QSqlDatabase::addDatabase("QSQLITE");
vc2DB.setDatabaseName(dbPath);
vc2DB.open();
QSqlQuery query;
query.exec("PRAGMA foreign_keys = ON;");
bool b = query.exec("select id from role where code = 'SU'");
if (!b) {
std::cerr << "Failed to open database: " << dbPath.toAscii().data() << std::endl;
exit(-1);
}
}
@

[developer]

there is not db path set @broadpeak

[gayu]

So u've to set the path for db

[developer]

why the table has been created fine.
also where to seta good path for ana pplication

[broadpeak]

[quote author="developer" date="1353499828"]there is not db path set @broadpeak[/quote]

What? I don't understand this.

But! If the open() function can't open your database, it will open with the given name an another database in QSQLITE! See your databaseS.

[developer]

it can open the database @broadpeek

[gayu]

even though the file does not exist, the SQLite will try to create it.

[broadpeak]

[quote author="developer" date="1353500452"]it can open the database @broadpeek[/quote]

Anyway, can you run (from your code) a simple SELECT on your database? Have you got a resultset?
Have you grant at all for your tables?

[developer]

ohhhhhhhhhh acutally its working with setting url a different databse opens and with just typing passwordmanager as databse name it works actaully the problem is with the table view thanks all problem solved i tried select staement and i got the result

[developer]

it also works after selecting select() thanks all

[broadpeak]

Ok, set your thread to [solved] :)