fix #4305

qgis · Dec 26, 2011 · 5d08c8b · 5d08c8b
1 parent 72a6434
commit 5d08c8b
Showing 1 changed file with 8 additions and 1 deletion.
diff --git a/src/app/qgsquerybuilder.cpp b/src/app/qgsquerybuilder.cpp
@@ -104,6 +104,7 @@ void QgsQueryBuilder::fillValues( int idx, int limit )
   {
     QStandardItem *myItem = new QStandardItem( values[i].toString() );
     myItem->setEditable( false );
+    myItem->setData( values[i] );
     mModelValues->insertRow( mModelValues->rowCount(), myItem );
   }
 }
@@ -267,7 +268,13 @@ void QgsQueryBuilder::on_lstFields_doubleClicked( const QModelIndex &index )
 
 void QgsQueryBuilder::on_lstValues_doubleClicked( const QModelIndex &index )
 {
-  txtSQL->insertPlainText( "'" + mModelValues->data( index ).toString() + "'" );
+  QVariant value = mModelValues->data( index, Qt::UserRole + 1 );
+  if( value.isNull() )
+    txtSQL->insertPlainText( "NULL" );
+  else if( value.type() == QVariant::Int || value.type() == QVariant::Double || value.type() == QVariant::LongLong )
+    txtSQL->insertPlainText( value.toString() );
+  else
+    txtSQL->insertPlainText( "'" + value.toString() + "'" );
 }
 
 void QgsQueryBuilder::on_btnLessEqual_clicked()