updating database

[locus]

Does qdatawidgetmapper update databases?

I used the code that can be found at the link below and modified it just to connect to my database(all i did was change "bool createConnections"; nothing else).

http://www.trolltech.com/developer/t...ntry&id=147264

I ran the code and got it to work. I changed

#if 1
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
#else
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
#endif

#if 1
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
#else
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
#endif

To copy to clipboard, switch view to plain text mode 

to

#if 0  //changed 1 to 0;thats all
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
#else
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
#endif

#if 0  //changed 1 to 0;thats all
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
#else
        model->setEditStrategy(QSqlTableModel::OnManualSubmit);
#endif

To copy to clipboard, switch view to plain text mode 

and the view was updated perfectly; using the mapped lineEdit . But when i go back to the command prompt and check the database, nothing has changed.

Can someone tell me how to update the database using the mapped widget?

My code follows the exact same procedure as that in the link, with only some formatting differences. My mapped widgets does not update the database, the ones in the code at the above URL does not update the database either.

[mcosta]

Hi,

setting the EditStrategy to QSqlTableModel::OnManualSubmit you must apply the changes with

bool QSqlTableModel::submitAll ()

bool QSqlTableModel::submitAll ()

To copy to clipboard, switch view to plain text mode 

or revert them with

void QSqlTableModel::revertAll ()

void QSqlTableModel::revertAll ()

To copy to clipboard, switch view to plain text mode 

.

In this way you can control all changes and apply them to the model only if are consistent with your application logic.

[locus]

Thanks for the response mcosta.

I should have metioned thought that i tried that (submitAll() that is), but for some reason it did not work

here are the relevant pieces of code that were added to the code found at the URL:

QPushButton *button =  new QPushButton("button");
 
hbox->addWidget(button);
 
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
 
connect(button,SIGNAL(clicked()),model,SLOT(submitAll()));
 
mapper.setSubmitPolicy(QDataWidgetMapper::ManualSubmit);

QPushButton *button =  new QPushButton("button");

hbox->addWidget(button);

model->setEditStrategy(QSqlTableModel::OnManualSubmit);

connect(button,SIGNAL(clicked()),model,SLOT(submitAll()));

mapper.setSubmitPolicy(QDataWidgetMapper::ManualSubmit);

To copy to clipboard, switch view to plain text mode 

i then ran the code and and clicked my button to call submitAll(), after pressing CTRl+S to call submit() for the mapper. The attribute value in the view changed, but the value in the database remains untouched.

i found somthing in the docs called :

QAbstractItemDelegate::SubmitModelCache

QAbstractItemDelegate::SubmitModelCache

To copy to clipboard, switch view to plain text mode 

don't know if it can help, nor do i know how to access the delegate being used by the view to set it.

It is supposed to tell the delegate to write all cached data to the database.

any suggestions will be greatly appreciated.

[locus]

For a detailed description of the problem and solution got to:


http://www.qtcentre.org/forum/f-qt-p...rror-5370.html