add_case_v


Description:

[ Version ( since = "4.2" ) ]
public SqlBuilderId add_case_v (SqlBuilderId test_expr, SqlBuilderId else_expr, SqlBuilderId[] when_array, SqlBuilderId[] then_array)

Creates a new CASE ... WHEN ... THEN ... ELSE ... END expression.

The WHEN expression and the THEN expression IDs are taken from the when_array and then_array at the same index, for each index inferior to when_array.length.

Parameters:

this

a SqlBuilder object

test_expr

the expression ID representing the test of the CASE, or 0

else_expr

the expression ID representing the ELSE expression, or 0

when_array

an array containing each WHEN expression ID, having at least when_array.length elements

then_array

an array containing each THEN expression ID, having at least when_array.length elements

args_size

the size of when_array and then_array

Returns:

the ID of the new expression, or 0 if there was an error