SqlChoose Method

Member of ISDatabaseHandler
Creates an SQL string containing this provider's equivalent of an CHOOSE function.

Syntax

ISDatabaseHandler.SqlChoose(index, valueList, [autoEscape])

Parameters

NameTypeOptionalByRefDescription
index String The index of the item in the list to choose. Can be a literal, eg 2, or an expression, eg Account.Status+1 If less than one or greater then valueList.count Null is returned.
valueList ISList The list of Values.
autoEscape Boolean Optional Indicates that all '[' and ']' characters appearing in the "index" 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