Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

asked 12 Feb '22, 08:46

jorgeftz's gravatar image

accept rate: 0%

Sqlanyhere 16

(12 Feb '22, 08:46) jorgeftz

Seems quite similar/related to this question...

(13 Feb '22, 07:36) Volker Barth

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

permanent link

answered 12 Feb '22, 10:18

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Solved. Thank you Mark!!

(12 Feb '22, 11:15) jorgeftz
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 12 Feb '22, 08:46

question was seen: 780 times

last updated: 13 Feb '22, 07:36