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** asked 12 Feb '22, 08:46 jorgeftz |
"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. answered 12 Feb '22, 10:18 Mark Culp Solved. Thank you Mark!!
(12 Feb '22, 11:15)
jorgeftz
|
Sqlanyhere 16
Seems quite similar/related to this question...