Creates an SQL string containing this provider's equivalent of an CASE function.

Syntax

ISDatabaseHandler.SqlCase(inputExpression, whenExpressionList, resultList, [autoEscape])

Parameters

NameTypeOptionalByRefDescription
inputExpression String The input expression to evaluate.
whenExpressionList ISList A list of when expressions.
resultList ISList A list of result values. Must have the same number of items as whenExpressionList, or one more to include an ELSE condition.
autoEscape Boolean Optional Indicates that all '[' and ']' characters appearing in inputExpression and whenExpressionLists should be replaced with the correct Escape characters for this Database Provider. If omitted, a value of False is assumed.

Return Value

String

A String value.

Member of:
ISDatabaseHandler
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0