Add iif SQL function to the list of known functions in Execute SQL tab

This adds the iif function to the list of known functions for which we offer tooltips in the Execute SQL tab. It was introduced in SQLite 3.32.0.
jixuqianxing · Jun 10, 2020 · ff37c90 · ff37c90
1 parent facbcec
commit ff37c90
Showing 1 changed file with 1 addition and 0 deletions.
diff --git a/src/SqlUiLexer.cpp b/src/SqlUiLexer.cpp
@@ -71,6 +71,7 @@ void SqlUiLexer::setupAutoCompletion()
             << "ifnull" + tr("(X,Y) The ifnull() function returns a copy of its first non-NULL argument, or NULL if both arguments are NULL.")
             << "instr" + tr("(X,Y) The instr(X,Y) function finds the first occurrence of string Y within string X and returns the number of prior characters plus 1, or 0 if Y is nowhere found within X.")
             << "hex" + tr("(X) The hex() function interprets its argument as a BLOB and returns a string which is the upper-case hexadecimal rendering of the content of that blob.")
+            << "iif" + tr("(X,Y,Z) The iif(X,Y,Z) function returns the value Y if X is true, and Z otherwise.")
             << "last_insert_rowid" + tr("() The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function.")
             << "length" + tr("(X) For a string value X, the length(X) function returns the number of characters (not bytes) in X prior to the first NUL character.")
             << "like" + tr("(X,Y) The like() function is used to implement the \"Y LIKE X\" expression.")