Anyone tell me what's wrong with this? I keep getting ElevateDB Error #700 An error was found in the script at line 119 and column 1 (Missing IF)

IF Mode = 'Callbacks' THEN
SET Creator = Creator + ' _fkUsers = '+ CAST(UserID AS VARCHAR) + '_CallBack';
ELSE IF Mode = 'Alarms' THEN
SET Creator = Creator + ' _fkUsers = '+ CAST(UserID AS VARCHAR) + ' _HideAlarm IS NOT NULL';
/*
ELSE
SET Creator = Creator + '_fkProjects = '+ CAST(ProjectID AS VARCHAR);
SET Creator = Creator +  ' AND ';
SET Creator = Creator +  ' (_HideSet = FALSE OR _HideAlarm IS NULL OR _HideAlarm <= CURRENT_DATE)';
SET Creator = Creator +  ' AND ';
SET Creator = Creator +  ' (C._Name IS NOT NULL OR W._Surname IS NOT NULL)';
*/
END IF;

Roy Lambert

Roy,

<< Anyone tell me what's wrong with this? I keep getting ElevateDB Error
#700 An error was found in the script at line 119 and column 1 (Missing IF)
>>

The SQL manual has a documentation error - the syntax is ELSEIF (all one
word) instead of ELSE IF.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>The SQL manual has a documentation error - the syntax is ELSEIF (all one
>word) instead of ELSE IF.

That could explain it Fortunately I could just use 3 separate IF END IFs to keep trying the conversion, and failing.

Roy Lambert