QtForum.org »
QtForum.org »- Qt »
Qt Programming »
- 1
- 2
Tuesday, May 6th 2008, 12:28pm
RE: DataBrowser problem.
>>Just little bit change.
Or no. That is a big change.
Well I think the following can be done if you hate to hardcode (and that might be best solution and that is not too hard after all.) all 18 db filling.
To write values to db.
Get all group box. In loop, check if the QGroupBox contains 2 QRadioButton and 2 (or whatever count) QGroupBox (the one draw back that QRadioButton and QGroupBox must be in some way tied (for example have same title and text string or objectName property some parts are the same or deducted from positions
well everything is possible)). If conditions are met there is QGroupBox, QRadioButton and QRadioButton - write their values to a db.
For sorting use proxy (as I mentioned before). Or there is another sql example.
This one sorts not bad (for test I sort TypeofSensor column. use ChannelID and correct substr values):
"SELECT * FROM Temp ORDER BY CASE WHEN CAST ( substr(TypeofSensor, 13, 5) AS INTEGER) == 0 THEN lower(TypeofSensor) ELSE CAST ( substr(TypeofSensor, 13, 5) AS INTEGER) END"
Example project (with _final_ widgets positions and hierarchy) would be good to look farther.
And please - attach png files.
Or no. That is a big change.
Well I think the following can be done if you hate to hardcode (and that might be best solution and that is not too hard after all.) all 18 db filling.
To write values to db.
Get all group box. In loop, check if the QGroupBox contains 2 QRadioButton and 2 (or whatever count) QGroupBox (the one draw back that QRadioButton and QGroupBox must be in some way tied (for example have same title and text string or objectName property some parts are the same or deducted from positions
well everything is possible)). If conditions are met there is QGroupBox, QRadioButton and QRadioButton - write their values to a db.For sorting use proxy (as I mentioned before). Or there is another sql example.
This one sorts not bad (for test I sort TypeofSensor column. use ChannelID and correct substr values):
"SELECT * FROM Temp ORDER BY CASE WHEN CAST ( substr(TypeofSensor, 13, 5) AS INTEGER) == 0 THEN lower(TypeofSensor) ELSE CAST ( substr(TypeofSensor, 13, 5) AS INTEGER) END"
Example project (with _final_ widgets positions and hierarchy) would be good to look farther.
And please - attach png files.
Fighting fire with fire.
Thursday, May 15th 2008, 11:23am
RE: DataBrowser problem.
Hi Messenger,
What ever you said.That i followed and tried to hardcode the application.still Baffeled.I think ter are some mistakes in my code
I attached code what ever i did in application.
This is the code functionality for when i click the PushButton ,I want to save the data in table .That table should be Corresponding GUI data saved in to database.
s.no / ChannelName / Type of sensor / Sensorvalue
1 / sparechannel / temperature / prt-100ohm
Please helpme Messenger,
Thankyou..
Regards,
Tavi.
What ever you said.That i followed and tried to hardcode the application.still Baffeled.I think ter are some mistakes in my code
I attached code what ever i did in application.
|
Source code |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
void spare_channel::on_pushButton_clicked()
{
QList<QRadioButton*> rbtns = this->findChildren<QRadioButton*>();
int i,j;
for (i = 0; i < rbtns.count(); ++i)
{
// lookup group box
QGroupBox *gb = qobject_cast<QGroupBox*>(rbtns.at(i)->parent());
if (gb && rbtns.at(i)->isChecked())
{
for(j=0;j<rbtns.count();++j)
{
QGroupBox *gb=qobject_cast<QGroupBox*>(rbtns.at(i)->parent());
if(gb&&rbtns.at(i)->isChecked())
{
QString qu("INSERT or REPLACE INTO Spar VALUES('%1', '%2','%3')");
qu = qu.arg(gb->title())
.arg(rbtns.at(i)->text())
.arg(rbtns.at(j)->text());
QSqlQuery q;
if (!q.exec(qu))
{
QMessageBox::information(this, "Failed SQL query", q.lastError().text() + "\n" + q.lastQuery());
}
}
}
}
}
}
|
This is the code functionality for when i click the PushButton ,I want to save the data in table .That table should be Corresponding GUI data saved in to database.
s.no / ChannelName / Type of sensor / Sensorvalue
1 / sparechannel / temperature / prt-100ohm
Please helpme Messenger,
Thankyou..
Regards,
Tavi.
This post has been edited 2 times, last edit by "tavi" (May 15th 2008, 2:34pm)
Friday, May 16th 2008, 8:40am
RE: DataBrowser problem.
Hi,
by hardcoding I have suggested to do all work by hand. Like
I have attached little example (the examining of objects hierarchy and...). Looks like works like is expected.
by hardcoding I have suggested to do all work by hand. Like
|
|
Source code |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
if (m_RadioButton1.isChecked()) // of course instead of m_RadioButton1 there must be meaningful name of the radio button.
{
if (m_RadioButton2.isChecked())
{
if (m_RadioButton3.isChecked())
{
...save to a database some values...
}
if (m_rbPressure10Atm.isChecked())
{
...save to db...
}
....
}
.....
}
...
|
I have attached little example (the examining of objects hierarchy and...). Looks like works like is expected.
Fighting fire with fire.
Monday, May 26th 2008, 11:51am
Hi messenger,
Thank you for ur reply, your Example 5 is working . But I changed my ui design ,that is Small ,Instead of title names of Group Box(Temperature& pressure) i put Select as the title name for both the groupBoxes.I wanted to save the RadioButton Text which i have selected. I wanted to save which RadioButton i have selected either Temperature or Pressure in the Type of Sensor field of the db. And the selected Radio Buttons from the select Group (5K or 10C or 100 C or 500C)to the value field of the db.
Regards
Thank you for ur reply, your Example 5 is working . But I changed my ui design ,that is Small ,Instead of title names of Group Box(Temperature& pressure) i put Select as the title name for both the groupBoxes.I wanted to save the RadioButton Text which i have selected. I wanted to save which RadioButton i have selected either Temperature or Pressure in the Type of Sensor field of the db. And the selected Radio Buttons from the select Group (5K or 10C or 100 C or 500C)to the value field of the db.
Thanks,
Quoted
Pls check the previous attachment.
Regards
- 1
- 2