Record update windowd entered data saving

**MarkoSan** · 6th January 2006, 06:21

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** · 6th January 2006, 08:10

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** · 6th January 2006, 08:23

Well, i got the statement:

Qt Code:

Switch view

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:

Qt Code:

Switch view

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** · 6th January 2006, 08:27

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

**MarkoSan** · 6th January 2006, 08:37

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** · 6th January 2006, 20:55

Maybe the problem is with MySQL 5.0?

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

**MarkoSan** · 6th January 2006, 21:26

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:

Qt Code:

Switch view

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:

Qt Code:

Switch view

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:

Qt Code:

Switch view

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** · 8th January 2006, 12:50

No one has idea????

**jacek** · 8th January 2006, 14:19

Try this(note the "!"):

Qt Code:

Switch view

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** · 8th January 2006, 14:36

Originally Posted by jacek

Try this(note the "!"):

Qt Code:

Switch view

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** · 8th January 2006, 15:23

Originally Posted by MarkoSan

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

How about this?

Qt Code:

Switch view

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

**MarkoSan** · 8th January 2006, 17:22

So, am I nut or what? This time submitAll failed and first qDebug() we have

Qt Code:

Switch view

QSqlQueryModel::lastError returned {...}
QSqlError::text returned {" " size=1}

QSqlQueryModel::lastError returned {...}
QSqlError::text returned {" " size=1}

To copy to clipboard, switch view to plain text mode

and after second qDebug() we have:

Qt Code:

Switch view

QSqlQueryModel::query returned	{...}
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}

QSqlQueryModel::query returned	{...}
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

What is going on?

**jacek** · 8th January 2006, 17:53

Originally Posted by MarkoSan

What is going on?

Indeed something strange is going on. What does QSqlError::type() return?

**MarkoSan** · 8th January 2006, 17:57

Ok, this is diagnostic code:

Qt Code:

Switch view

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

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

To copy to clipboard, switch view to plain text mode

This is very very strange:

Qt Code:

Switch view

QSqlError::type returned    NoError

QSqlError::type returned    NoError

To copy to clipboard, switch view to plain text mode

NoError has been reported!!! How come???

**wysota** · 8th January 2006, 17:58

SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.I ME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,u

This stinks... What is the table "kraj" doing here if it's not in the "FROM" part of the query? On the other hand, looks like "u" is not used here, so why is it in the statement? Is that a complete output from lastQuery? Is this a SqlTableModel or QSqlRelationalTableModel? How come SqlTableModel has more than one table in use? Is that last query connected with the model at all?

**MarkoSan** · 8th January 2006, 18:03

Originally Posted by wysota

This stinks... What is the table "kraj" doing here if it's not in the "FROM" part of the query? On the other hand, looks like "u" is not used here, so why is it in the statement? Is that a complete output from lastQuery? Is this a SqlTableModel or QSqlRelationalTableModel? How come SqlTableModel has more than one table in use? Is that last query connected with the model at all?

You are right. Does submitAll() generated any SQL statement? The reason I ask is that that statement is responsible for displaying data in QSqlRelationalTableModel and it works fine and lastQuery after sumbitAll still reports that statement, which is obviously not statement for inserting records.

The statement that I get from debuger is:

Qt Code:

Switch view

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

**wysota** · 8th January 2006, 18:14

Do you have access to that MySQL's query log? Could you check last queries which are executed before getting that wrong behaviour?

**MarkoSan** · 9th January 2006, 08:02

Here is log file listing:

Qt Code:

Switch view

D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.16-nt-log. started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
060108 22:42:59          1 Connect     root@localhost on possystem
              1 Init DB     possystem
              1 Field List  stranka 
              1 Field List  stranka 
              1 Field List  stranka 
              1 Query       show index from stranka
              1 Field List  stranka 
              1 Query       SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.IME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,ulica,kraj WHERE (stranka.ULICA=ulica.ulica and stranka.POSTA_STEVILKA=kraj.postna_stevilka)
D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.16-nt-log. started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
060109  8:53:59          1 Connect     root@localhost on 
              1 Query       SET SESSION interactive_timeout=1000000
              1 Query       SELECT @@sql_mode
              1 Query       SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
              1 Query       SET NAMES utf8
              2 Connect     root@localhost on 
              2 Query       SET SESSION interactive_timeout=1000000
              2 Query       SELECT @@sql_mode
              2 Query       SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
              2 Query       SET NAMES utf8
              2 Quit       
060109  8:59:48          3 Connect     root@localhost on possystem
              3 Init DB     possystem
              3 Field List  stranka 
              3 Field List  stranka 
              3 Field List  stranka 
              3 Query       show index from stranka
              3 Field List  stranka 
              3 Query       SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.IME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,ulica,kraj WHERE (stranka.ULICA=ulica.ulica and stranka.POSTA_STEVILKA=kraj.postna_stevilka)
060109  8:59:56          3 Quit       
060109  9:00:08          1 Query       SHOW VARIABLES LIKE 'datadir'
              1 Query       SHOW VARIABLES LIKE 'log_error'

D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.16-nt-log. started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
060108 22:42:59          1 Connect     root@localhost on possystem
              1 Init DB     possystem
              1 Field List  stranka 
              1 Field List  stranka 
              1 Field List  stranka 
              1 Query       show index from stranka
              1 Field List  stranka 
              1 Query       SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.IME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,ulica,kraj WHERE (stranka.ULICA=ulica.ulica and stranka.POSTA_STEVILKA=kraj.postna_stevilka)
D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.16-nt-log. started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
060109  8:53:59          1 Connect     root@localhost on 
              1 Query       SET SESSION interactive_timeout=1000000
              1 Query       SELECT @@sql_mode
              1 Query       SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
              1 Query       SET NAMES utf8
              2 Connect     root@localhost on 
              2 Query       SET SESSION interactive_timeout=1000000
              2 Query       SELECT @@sql_mode
              2 Query       SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
              2 Query       SET NAMES utf8
              2 Quit       
060109  8:59:48          3 Connect     root@localhost on possystem
              3 Init DB     possystem
              3 Field List  stranka 
              3 Field List  stranka 
              3 Field List  stranka 
              3 Query       show index from stranka
              3 Field List  stranka 
              3 Query       SELECT stranka.SIFRA,stranka.DS,stranka.PRIIMEK,stranka.IME,ulica.naziv,stranka.STEVILKA_ULICE,kraj.naziv_kraja FROM stranka,ulica,kraj WHERE (stranka.ULICA=ulica.ulica and stranka.POSTA_STEVILKA=kraj.postna_stevilka)
060109  8:59:56          3 Quit       
060109  9:00:08          1 Query       SHOW VARIABLES LIKE 'datadir'
              1 Query       SHOW VARIABLES LIKE 'log_error'

To copy to clipboard, switch view to plain text mode

I do not see INSERT statement anywhere!!

Thread: Record update windowd entered data saving

Thread Tools

Search Thread

Display

Hybrid View

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Re: Record update windowd entered data saving

Update window problem [DESPERATE - NOT SOLVED]

Bookmarks

Bookmarks

Posting Permissions