Hello all...I have a dwo that has a SQL Select statement
with the followings lines:

SELECT "dba"."judge"."judg_person_id" ,
"dba"."judge"."last_name" ,
"dba"."judge"."first_name" ,
"dba"."judge"."middle_name" ,
"dba"."judge"."pers_job_title",
"dba"."judge"."comment"
FROM "dba"."judge"
WHERE ( "dba"."judge"."judg_person_id" = :ra_judge_id )

The SELECT statement works fine in the dwo...but when I try
to do an insert in the dwo from the PowerBuilder window, I
get:

A database error has occurred.

Database error code: -131

Database error message:
SQLSTATE=37000
[Sybase][ODBC Driver][SQL Anywhere] Syntax error near
'comment' on line 1

No changes made to database.

INSERT INTO
judge(judg_person_id,last_name,first_name,middle_n ame,pers_job_title
,comment) VALUES(??????)

I understand that the column "comment" is a reserved word in
SQLAnywhere 11.0.1 but I have it double quoted above. Also,
in DB Profile, I have the "Enclose Table and Column Names in
Quotes" checked with an Identifier Quote Character = '"'

Any clue as to what is causing this issue? Any info would be
greatly appreciated...

Since this quoting is managed from the PB environment
[?PBDB?] it would be best to post this question on the
PB newsgroups.

You probably just need to escape the double quote
somehow .... as in ....
Identifier Quote Character = '""'
Identifier Quote Character = '~"'
or even
Identifier Quote Character = '~~~"'
depending upon the #levels of parsing
involved .... but it's been a decade or
more since I actively support PBScript
..... so .... other newsgroups is still a better
way of going

One of these should do:

sybase.public.powerbuilder.database
sybase.public.powerbuilder.datawindow
sybase.public.powerbuilder.general,


<Mark> wrote

Thanks Nick, will do...