send signal from QCombobox

[raphaelf]

Hi Guys..
like that it works, but just if i dobleclick my combobox

#include "test.h"
 
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QTextEdit>
#include <QStatusBar>
#include <QAbstractItemView>
#include <QEvent>
 
 
 
 
MainWindow::MainWindow()
 
    {
        ui.setupUi(this);
        ui.sprache_cb->installEventFilter(this);
 
 
        connect(ui.actionverbinden, SIGNAL(triggered()), this, SLOT(verbinden()));
 
 
    }
 
bool MainWindow::verbinden()
{
	 	QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("pcpsr5");
        db.setDatabaseName("DRIVER={SQL Server};SERVER=pcpsr5;DATABASE=inventar;UID=sa;PWD=");
        db.setUserName("sa");
        db.setPassword("");
        if(!db.open())
        {
    	QMessageBox::information(this,"",db.lastError().text());
        return false;
    	}    
        else
        return true;
}
void MainWindow::selectSprache()
{
	ui.sprache_cb->clear(); 
	ui.sprache_cb->insertItem(0,""); 
	QSqlQuery select (" select sprache from sprache_tbl");
	while(select.next())
	{
		QString sprachen = select.value(0).toString();
		ui.sprache_cb->insertItem(1, sprachen);
	}
 
}
 
bool MainWindow::eventFilter( QObject *o, QEvent *e )    
{        
	if ( e->type() == QEvent::MouseButtonPress )         
	{            
		selectSprache();            
		return TRUE;       
	} 
	else         
		return FALSE;        
 
}

#include "test.h"

#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QTextEdit>
#include <QStatusBar>
#include <QAbstractItemView>
#include <QEvent>




MainWindow::MainWindow()
         
    {
        ui.setupUi(this);
        ui.sprache_cb->installEventFilter(this);

        
        connect(ui.actionverbinden, SIGNAL(triggered()), this, SLOT(verbinden()));
        
       
    }
    
bool MainWindow::verbinden()
{
	 	QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("pcpsr5");
        db.setDatabaseName("DRIVER={SQL Server};SERVER=pcpsr5;DATABASE=inventar;UID=sa;PWD=");
        db.setUserName("sa");
        db.setPassword("");
        if(!db.open())
        {
    	QMessageBox::information(this,"",db.lastError().text());
        return false;
    	}    
        else
        return true;
}
void MainWindow::selectSprache()
{
	ui.sprache_cb->clear(); 
	ui.sprache_cb->insertItem(0,""); 
	QSqlQuery select (" select sprache from sprache_tbl");
	while(select.next())
	{
		QString sprachen = select.value(0).toString();
		ui.sprache_cb->insertItem(1, sprachen);
	}
	
}

bool MainWindow::eventFilter( QObject *o, QEvent *e )    
{        
	if ( e->type() == QEvent::MouseButtonPress )         
	{            
		selectSprache();            
		return TRUE;       
	} 
	else         
		return FALSE;        
    
}

To copy to clipboard, switch view to plain text mode 

[zlatko]

try release event use

[raphaelf]

Hi!
I get new values just if i click twice..and on release the small button right from the combobox stay active (like a toogle button) until a click again ;(

QEvent::MouseButtonRelease

QEvent::MouseButtonRelease

To copy to clipboard, switch view to plain text mode 

May be its not the right way to send a Signal from the ComboBox..

[raphaelf]

Hi,
"QEvent::FocusIn" looks to work but i have a symptom..if i ordered my query the results are interchanged
combo: x,f,a
Query Analyzer: a,f,x

"select sprache from sprache_tbl order by sprache"

[jpn]

Hi,
"QEvent::FocusIn" looks to work but i have a symptom..if i ordered my query the results are interchanged
combo: x,f,a
Query Analyzer: a,f,x

"select sprache from sprache_tbl order by sprache"

Use "order by sprache desc" in your sql statement or add items to the combo box in reverse order, see last() and previous().

[raphaelf]

Hi jpn!
Thank you very much for your spended time..I have downloaded the example an i will use "desc" for my Query..

Thanks all for the best support!

[jpn]

Hi!
I get new values just if i click twice..and on release the small button right from the combobox stay active (like a toogle button) until a click again ;(

Supposedly you want to populate the combo box only once, so maybe you could remove the event filter right after receiving the first appropriate event.

Anyhow, I have included an example of the solution I suggested earlier...