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

Syntax

ISDatabaseProviderUtilitiesBase.SqlChoose(index, valueList)

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.

Return Value

String

A String value.

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