Record update windowd entered data saving

[MarkoSan]

I have an QSqlTabelModel filled with data from three sql tables. When I press in customer browser button "Insert record" or "Change record", mthe update record window show, which contain several QLineEdit widgets. How do I save entered data into database? My exact question is, how to convert every QLineEdit.text() into corespoding record field and then save it?

const int INSERT_RECORD_AT_END=-1;
 
        QSqlRecord cDataRecord;
 
        cDataRecord.setValue("SIFRA", m_pUpdateWindow->GetCustomerID()->text());
        cDataRecord.setValue("DS", m_pUpdateWindow->GetTaxNumber()->text());
        cDataRecord.setValue("PRIIMEK", m_pUpdateWindow->GetSurname()->text());
        cDataRecord.setValue("IME", m_pUpdateWindow->GetName()->text());
        //cDataRecord.setValue("ULICA", m_pUpdateWindow->GetStreetID()->text());
        cDataRecord.setValue("STEVILKA_ULICE", m_pUpdateWindow->GetStreetNumber()->text());
        cDataRecord.setValue("POSTA_STEVILKA", m_pUpdateWindow->GetZipCode()->text());
 
        if(m_pTableModel->insertRecord(INSERT_RECORD_AT_END, cDataRecord))
        {
            QSqlError error=m_pTableModel->lastError();
            if(error.type()!=QSqlError::NoError)
            {
                qDebug() << m_pTableModel->query().lastQuery();
            }   // if
        }   // if

const int INSERT_RECORD_AT_END=-1;

        QSqlRecord cDataRecord;
        
        cDataRecord.setValue("SIFRA", m_pUpdateWindow->GetCustomerID()->text());
        cDataRecord.setValue("DS", m_pUpdateWindow->GetTaxNumber()->text());
        cDataRecord.setValue("PRIIMEK", m_pUpdateWindow->GetSurname()->text());
        cDataRecord.setValue("IME", m_pUpdateWindow->GetName()->text());
        //cDataRecord.setValue("ULICA", m_pUpdateWindow->GetStreetID()->text());
        cDataRecord.setValue("STEVILKA_ULICE", m_pUpdateWindow->GetStreetNumber()->text());
        cDataRecord.setValue("POSTA_STEVILKA", m_pUpdateWindow->GetZipCode()->text());
        
        if(m_pTableModel->insertRecord(INSERT_RECORD_AT_END, cDataRecord))
        {
            QSqlError error=m_pTableModel->lastError();
            if(error.type()!=QSqlError::NoError)
            {
                qDebug() << m_pTableModel->query().lastQuery();
            }   // if
        }   // if

To copy to clipboard, switch view to plain text mode 

Is it maybe problem in insertRecord paramaters?

[wysota]

QSqlRecord rec;
rec.setValue("id", lineedit1->text());
rec.setValue("name", lineedit2->text());
rec.setValue("address", lineedit3->text());
 
//...
model->insertRecord(-1, rec);

QSqlRecord rec;
rec.setValue("id", lineedit1->text());
rec.setValue("name", lineedit2->text());
rec.setValue("address", lineedit3->text());

//...
model->insertRecord(-1, rec);

To copy to clipboard, switch view to plain text mode 

[MarkoSan]

QSqlRecord rec;
rec.setValue("id", lineedit1->text());
rec.setValue("name", lineedit2->text());
rec.setValue("address", lineedit3->text());
 
//...
model->insertRecord(-1, rec);

QSqlRecord rec;
rec.setValue("id", lineedit1->text());
rec.setValue("name", lineedit2->text());
rec.setValue("address", lineedit3->text());

//...
model->insertRecord(-1, rec);

To copy to clipboard, switch view to plain text mode 

Ok, but how does Qt knows which table write to? Or, if i change the name of field with sql administrator, how to handle that kind of changes?

[sunil.thaha]

Well your model knows. Don't they ?
Your model1 should be some what like this

QSqlTableModel *model = new QSqlTableModel;
        model->setTable("employee");

QSqlTableModel *model = new QSqlTableModel;
        model->setTable("employee");

To copy to clipboard, switch view to plain text mode 

[MarkoSan]

Well your model knows. Don't they ?
Your model1 should be some what like this

QSqlTableModel *model = new QSqlTableModel;
        model->setTable("employee");

QSqlTableModel *model = new QSqlTableModel;
        model->setTable("employee");

To copy to clipboard, switch view to plain text mode 

Ahaaaam, there is a connection, I see now. Thank you.

[MarkoSan]

Hwo do I then convert data types (QLineEdit.text() returns QString) into SQL data types?

[wysota]

What kind of fields? Doesn't providing them as strings work?

[MarkoSan]

Nope, it adds a field, I can see that, but record that wass added is empty. In sql database scheme i have BIGINT(20), VARCHAR(255) and so on. Do I need conversion at all or is there something else wrong? Or, how do I refresh the table?

[wysota]

You shouldn't need any conversions. Maybe you should try using the version of setValue with field indexes and not field names.

[MarkoSan]

God damn, I tried both setValue versions, I took a look at sql statement, which executes, all without errors (QSqlError returns NoError). insertRecord statement returns TRUE (which is by the docs OK), but data are still not visible. Any other idea??

[wysota]

Are they inserted into the database and not visible in the application or not inserted at all? What happens if you execute the same query "by hand"?

[MarkoSan]

Well, i got the statement:

QSqlQuery::lastQuery returned    {"SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.IME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,u" size=217}

QSqlQuery::lastQuery returned    {"SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.IME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,u" size=217}

To copy to clipboard, switch view to plain text mode 

from the code:

QSqlRecord cDataRecord;
 
        cDataRecord.setValue(QString("SIFRA"), m_pUpdateWindow->GetCustomerID()->text());
        cDataRecord.setValue(QString("DS"), m_pUpdateWindow->GetTaxNumber()->text());
        cDataRecord.setValue(QString("PRIIMEK"), m_pUpdateWindow->GetSurname()->text());
        cDataRecord.setValue(QString("IME"), m_pUpdateWindow->GetName()->text());
        //cDataRecord.setValue("ULICA", m_pUpdateWindow->GetStreetID()->text());
        cDataRecord.setValue(QString("STEVILKA_ULICE"), m_pUpdateWindow->GetStreetNumber()->text());
        cDataRecord.setValue(QString("POSTA_STEVILKA"), m_pUpdateWindow->GetZipCode()->text());
        if(m_pTableModel->insertRecord(INSERT_RECORD_AT_END, cDataRecord))
        {
            QSqlError error=m_pTableModel->lastError();
            if(error.type()!=QSqlError::NoError)
            {
                qDebug() << m_pTableModel->query().lastQuery();
            }   // if
        }   // if

QSqlRecord cDataRecord;
        
        cDataRecord.setValue(QString("SIFRA"), m_pUpdateWindow->GetCustomerID()->text());
        cDataRecord.setValue(QString("DS"), m_pUpdateWindow->GetTaxNumber()->text());
        cDataRecord.setValue(QString("PRIIMEK"), m_pUpdateWindow->GetSurname()->text());
        cDataRecord.setValue(QString("IME"), m_pUpdateWindow->GetName()->text());
        //cDataRecord.setValue("ULICA", m_pUpdateWindow->GetStreetID()->text());
        cDataRecord.setValue(QString("STEVILKA_ULICE"), m_pUpdateWindow->GetStreetNumber()->text());
        cDataRecord.setValue(QString("POSTA_STEVILKA"), m_pUpdateWindow->GetZipCode()->text());
        if(m_pTableModel->insertRecord(INSERT_RECORD_AT_END, cDataRecord))
        {
            QSqlError error=m_pTableModel->lastError();
            if(error.type()!=QSqlError::NoError)
            {
                qDebug() << m_pTableModel->query().lastQuery();
            }   // if
        }   // if

To copy to clipboard, switch view to plain text mode 

There is no INSERT statement at all, what the heck is going on??

[wysota]

Try calling submit() or submitAll() on the model.

[MarkoSan]

Same result, empty record added to table, when I reopen the window, this empty record is not shown, so I neither does add empty neither filled record to database. Is maybe problem in QSqlDelegate?

[wysota]

Maybe the problem is with MySQL 5.0?

Did you try debugging to see if Qt even tries to fill those fields?

[MarkoSan]

As i posted earlier, I think the statement:
QSqlQuery::lastQuery returned "SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.I ME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_k raja FROM stranka,u"size=217
,which is created in method insertRecord is not correct.

Since I am total newbie in SQL, am I right or not?

It seems, but it is not logical, that method insertRecord does not create an SQL statment, but it should, as I understand the whole thing.

Or maybe, in the docs there is definition of method:

bool QSqlTableModel::insertRecord ( int [I]row[/I], const [URL="http://www.qtcentre.org/forum/qsqlrecord.html"][COLOR=#0000ff][U]QSqlRecord[/U][/COLOR][/URL] & [I]record[/I] )

bool QSqlTableModel::insertRecord ( int [I]row[/I], const [URL="http://www.qtcentre.org/forum/qsqlrecord.html"][COLOR=#0000ff][U]QSqlRecord[/U][/COLOR][/URL] & [I]record[/I] )

To copy to clipboard, switch view to plain text mode 

The statement in my project is:

if(m_pTableModel->insertRecord(INSERT_RECORD_AT_END, cDataRecord))

if(m_pTableModel->insertRecord(INSERT_RECORD_AT_END, cDataRecord))

To copy to clipboard, switch view to plain text mode 

cDataRecord is declared as:

QSqlRecord cDataRecord;

QSqlRecord cDataRecord;

To copy to clipboard, switch view to plain text mode 

As far as I can see, the second parameter is reference to sql record, but i pass like insertRecord(-1, cDataRecord), as seen earlier. Is this ok or not?

[MarkoSan]

No one has idea????

[jacek]

Try this(note the "!"):

if( ! m_pTableModel->insertRecord( INSERT_RECORD_AT_END, cDataRecord ) )
{
   qDebug() << m_pTableModel->lastError().text();
   qDebug() << m_pTableModel->query().lastQuery();
}

if( ! m_pTableModel->insertRecord( INSERT_RECORD_AT_END, cDataRecord ) )
{
   qDebug() << m_pTableModel->lastError().text();
   qDebug() << m_pTableModel->query().lastQuery();
}

To copy to clipboard, switch view to plain text mode 

[MarkoSan]

Try this(note the "!"):

if( ! m_pTableModel->insertRecord( INSERT_RECORD_AT_END, cDataRecord ) )
{
   qDebug() << m_pTableModel->lastError().text();
   qDebug() << m_pTableModel->query().lastQuery();
}

if( ! m_pTableModel->insertRecord( INSERT_RECORD_AT_END, cDataRecord ) )
{
   qDebug() << m_pTableModel->lastError().text();
   qDebug() << m_pTableModel->query().lastQuery();
}

To copy to clipboard, switch view to plain text mode 

I did that, but since operation is sucessfull, qDebug statements are skipped.

[jacek]

I did that, but since operation is sucessfull, qDebug statements are skipped.

How about this?

m_pTableModel->insertRecord( INSERT_RECORD_AT_END, cDataRecord );
if( m_pTableModel->submitAll() )
{
   qDebug() << "Data submitted successfully";
}
else {
   qDebug() << m_pTableModel->lastError().text();
   qDebug() << m_pTableModel->query().lastQuery();
}

m_pTableModel->insertRecord( INSERT_RECORD_AT_END, cDataRecord );
if( m_pTableModel->submitAll() )
{
   qDebug() << "Data submitted successfully";
}
else {
   qDebug() << m_pTableModel->lastError().text();
   qDebug() << m_pTableModel->query().lastQuery();
}

To copy to clipboard, switch view to plain text mode