Hi , I'm trying to run that query, but Im getting bellow error. SELECT GroupID, Label, Comment, Provider FROM dbo.mxdata_uggroupstable structure: CREATE TABLE [dbo].[mxdata_uggroups] ([GroupID] INTEGER DEFAULT AUTOINCREMENT NOT NULL,[Label] varchar(300) NULL,[Comment] TEXT NULL, [Provider] VARCHAR (10) not null, PRIMARY KEY ([GroupID])); **Error executing query: SQL Error State:42000, Native Error Code: FFFFFF7D, ODBC Error: [Sybase][ODBC Driver][SQL Anywhere]Syntax error near 'Comment' on line 4** |
"Comment" is a reserved word. You need to quote it when you use it in your query. See the documentation on reserved words for more information. Solved. Thank you Mark!!
(12 Feb '22, 11:15)
jorgeftz
|
Sqlanyhere 16
Seems quite similar/related to this question...