Error executing query

[former_SQLA_member1694965]

Hi ,

I'm trying to run that query, but Im getting bellow error.

SELECT GroupID, Label, Comment, Provider FROM dbo.mxdata_uggroups

table 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**

[former_SQLA_member1694965]

Sqlanyhere 16

[VolkerBarth]

Seems quite similar/related to this question...

[MarkCulp · Accepted solution]

"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.

[former_SQLA_member1694965 · Accepted solution]

Solved. Thank you Mark!!