If you want to remove empty line
Evaluate ( "List( \"" & Substitute ( resultOfSQL ; [ "\"" ; "\\\"" ] ; [ ¶ ; "\";\"" ] ) & "\")" )
Or, you use pk in WHERE then it may be fast enough querying 4 times.
SELECT a FROM Table WHERE IDpk = ? AND a IS NOT NULL
SELECT b FROM Table WHERE IDpk = ? AND b IS NOT NULL
SELECT c FROM Table WHERE IDpk = ? AND c IS NOT NULL
SELECT d FROM Table WHERE IDpk = ? AND d IS NOT NULL
//FMSQL doesn't change the order of unionized result.
hoo? it can be List() ed without UNION more stablly?
I think you have missed the thing I am looking for.
I need the values in variables separately. Currently this is done with four separate queries into separate variables. This is slower than I would like and I would like to get it into one query to cut down on the query time. However sometimes there is a null value in the data.
So instead of getting
$sqlResult = "a¶b¶c¶d"
and then using
There is an issue when one or more of the result parameters are missing. For example, when b is null/empty:
$sqlResult = "a¶c¶d"
So your example SQL is something different.
returns always 4 values regardless of NULL or not, using column delimiter as ¶ you can get 4 lines