Esempio n. 1
0
void SQLToolWidget::runSQLCommand(void)
{
    try
    {
        ResultSet res;
        QString cmd=sql_cmd_txt->textCursor().selectedText();

        if(cmd.isEmpty())
            cmd=sql_cmd_txt->toPlainText();

        sql_cmd_conn.executeDMLCommand(cmd, res);
        registerSQLCommand(cmd);

        results_parent->setVisible(!res.isEmpty());
        export_tb->setEnabled(!res.isEmpty());
        msgoutput_lst->setVisible(res.isEmpty());

        if(results_tbw->isVisible())
            fillResultsTable(res);
        else
        {
            QLabel *label=new QLabel(trUtf8("SQL command successfully executed. <em>Rows affected <strong>%1</strong></em>").arg(res.getTupleCount()));
            QListWidgetItem *item=new QListWidgetItem;

            item->setIcon(QIcon(":/icones/icones/msgbox_info.png"));
            msgoutput_lst->clear();
            msgoutput_lst->addItem(item);
            msgoutput_lst->setItemWidget(item, label);
        }
    }
    catch(Exception &e)
    {
        showError(e);
    }
}