Error executing query

-2

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

sybase-central

asked 12 Feb '22, 08:46

jorgeftz
24●3●3●6
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

flat view

One Answer:

active answers oldest answers newest answers popular answers

"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 Culp
24.8k●9●139●295
accept rate: 41%

Solved. Thank you Mark!!

(12 Feb '22, 11:15) jorgeftz

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

sybase-central ×125

question asked: 12 Feb '22, 08:46

question was seen: 387 times

last updated: 13 Feb '22, 07:36

SAP SQL Anywhere

Error executing query

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

Follow this question

Related questions