VistaDB 5
IF / ELSE
IF / ELSE can be used to add execute logic paths to your dynamically allocated SQL code.

 

IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]

Example

If / Else Example
Copy Code
IF (155.55 = 155.55)
select 'Yes!';
ELSE
select 'No!';
 

See Also