Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
"End of Alter Statement" expected - why? |
Sat, Dec 9 2023 6:18 AM | Permanent Link |
Phil Frank MealService Software | The syntax here appears to be correct:
ALTER TABLE IF EXISTS ASSESSMENTS ADD COLUMN IF NOT EXISTS BMI VARCHAR(3); but I'm getting an End of Alter Statement expected, instead found 'EXISTS'. I get that message whether I use a valid table name, or not. The syntax is taken directly from the docs. I've typed the statement directly into dbsys, so it can't be an issue of having copied and pasted thereby including any hidden characters. If I remove the 'IF EXISTS' testing for the existence of the table I get this message: Left parenthesis expected after IF keyword, instead found NOT in table column. Any thoughts? Phil |
Sat, Dec 9 2023 6:25 AM | Permanent Link |
Phil Frank MealService Software | NEVER MIND! I'm in the process of upgrading tables, and I was making the mistake of running that in dbsys 3 rather than dbsys 4! |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |