Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
IF in script |
Mon, Sep 29 2008 11:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Sep 29 2008 1:28 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Sep 29 2008 1:53 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |