Record update windowd entered data saving

**wysota** · 17th January 2006, 14:46

Originally Posted by MarkoSan

Whatever I do, I cannot get data into database!!!! I am going mad!!!

Please provide a minimal compilable example which reproduces the problem. Your code is too complex (and incomplete) for us to test on our own machines.

**MarkoSan** · 18th January 2006, 11:01

Originally Posted by wysota

Please provide a minimal compilable example which reproduces the problem. Your code is too complex (and incomplete) for us to test on our own machines.

I tried, but zip file is too big and i do not know how to distribure sql databse.

**MarkoSan** · 18th January 2006, 11:44

Is the situation maybe connected with http://www.trolltech.com/developer/t...entry&id=86645, what do you think?

**wysota** · 18th January 2006, 12:08

Originally Posted by MarkoSan

I tried, but zip file is too big and i do not know how to distribure sql databse.

So make it smaller. The example is to be minimal. We don't need your database, just a table schema and some sample data.

**MarkoSan** · 18th January 2006, 12:23

Here is minimal project file and sources (VC++ 6.0 Service Pack 6, Qt 4.0.1). After unziping in .sql file there are table declarations and sample data.

**fane** · 18th January 2006, 18:50

I have managed to make it work but I use Qt 4.1.0 on WinXp and MySQL 4.1.11. Similar code didn't work on Qt 4.0.0, but I don't know about 4.0.1. My modifications are commented with 'modified by fane' (hope I didn't miss anyone), and of course your MySQL root password has to be changed.
I have appended two QSqlFields to the record retrieved with model->record() named "ULICA" and "POSTA_STEVILKA", set their value with QSqlRecord::setValue(). I have modified the edit strategy to be OnRowChange and removed the setValue() call for the "SIFRA" field which is autoincremented by MySQL.
I guess you have to move to Qt 4.1.0 according to this