fix #2766

jef-n · jef-n · commit 9843384a765e · 2012-03-06T13:52:31.000+01:00
diff --git a/src/gui/qgsquerybuilder.cpp b/src/gui/qgsquerybuilder.cpp
@@ -285,7 +285,7 @@ void QgsQueryBuilder::on_lstValues_doubleClicked( const QModelIndex &index )
   else if ( value.type() == QVariant::Int || value.type() == QVariant::Double || value.type() == QVariant::LongLong )
     txtSQL->insertPlainText( value.toString() );
   else
-    txtSQL->insertPlainText( "'" + value.toString() + "'" );
+    txtSQL->insertPlainText( "'" + value.toString().replace( "'", "''" ) + "'" );
 }
 
 void QgsQueryBuilder::on_btnLessEqual_clicked()

Original file line number	Diff line number	Diff line change
`@@ -285,7 +285,7 @@ void QgsQueryBuilder::on_lstValues_doubleClicked( const QModelIndex &index )`
`285`	`285`	`else if ( value.type() == QVariant::Int \|\| value.type() == QVariant::Double \|\| value.type() == QVariant::LongLong )`
`286`	`286`	`txtSQL->insertPlainText( value.toString() );`
`287`	`287`	`else`
`288`		`- txtSQL->insertPlainText( "'" + value.toString() + "'" );`
	`288`	`+ txtSQL->insertPlainText( "'" + value.toString().replace( "'", "''" ) + "'" );`
`289`	`289`	`}`
`290`	`290`
`291`	`291`	`void QgsQueryBuilder::on_btnLessEqual_clicked()`