Changing SQL Value

pemoamsi

Hy,

I'm using the Relation Table Model Example, but I don't know witch is the location of the database and why I cannot find the itens there,

How can I change to my "example.sqlite" as the source?

SGaist

Hi,

IIRC the SQL examples uses in memory databases so there are no files there.

Look at connection.h in the sql example folder

Hope it helps

pemoamsi

I've already changed this "db.setDatabaseName(":memory:");" to "db.setDatabaseName("example.sqlite");", but no lock yeat :(

SGaist

Do you have example.sqlite in the same folder as your executable ?

You have two options:

copy your example.sqlite in the same folder as your executable
give the complete path when calling setDatabaseName

pemoamsi

@static bool createConnection()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("t_job.sqlite");
if (!db.open()) {
QMessageBox::critical(0, qApp->tr("Cannot open database"),
qApp->tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."), QMessageBox::Cancel);
return false;
}

QSqlQuery query;
query.exec&#40;"create table examp (id int primary key, "
           "firstname varchar(20&#41;, lastname varchar(20&#41;)");
query.exec&#40;"insert into examp values(1, 'Ordem1.zip', '10:20'&#41;"&#41;;
query.exec&#40;"insert into examp values(2, 'Text', '12:00'&#41;"&#41;;
query.exec&#40;"insert into examp values(3, 'Low', '9:00'&#41;"&#41;;
query.exec&#40;"insert into examp values(1, 'c:wampfolder', '10:00'&#41;"&#41;;
query.exec&#40;"insert into examp values(2, '10.32.1.1Text', '11:00'&#41;"&#41;;


return true;

}@

I have all files in the right location but...
I think my problem may be here:

@TableEditor::TableEditor(const QString &myexample, QWidget *parent)
: QWidget(parent)
{
model = new QSqlTableModel(this);
//model->setTable(tableName);
model->setTable(myexample);

...
@

SGaist

What does myexample contain ?

pemoamsi

myexample is a Table with id, username, email and status

SGaist

I meant what is the myexample variable value ?

pemoamsi

I think I didn't understand the question... variable values?

myexample is a table like this

SGaist

In your TableEditor constructor, you have the myexample parameter, what does it contain ?