Hello all...I am migrating our Sybase ASA databases from ASA
9.03 to SQLAnyWhere 11.0.1. I have noticed that I must use
double quotes in columns which are reserved words in order
to prevent any syntax errors when executing the SQL. This
works quite well in ISQL 11.0.1 but when I try to use the
double quotes in datawindow object, say:

SELECT "opinions"."opinion_number",
"opinions"."date_recieved",
"opinions"."from",
"opinions"."responsible_attorney_id",
"opinions"."date_of_response"
FROM "opinions"

and I try to do an INSERT through the datawindow painter it
fails and says:
SQLSATE = 37000
[Sybase][ODBC Driver][SQL Anywhere] Syntax error near 'from'
on line 1

The INSERT statement works quite well in ISQL 11.0.1 but
when I try to insert through the PowerBuilder dwo, it
generates the above statement. Any clue as to what might be
causing this problem within PowerBuilder?

In the PowerBuilder "Database Profile Setup ODBC", have you tried to
set "Enclose Table and Column Names in Quotes" to checked and user
double quote (") as "Identifier Quote Char"? At least this works for
me, if i use different dbms than SQL Anyhwere.

Marc

Marc, this works, the only problem is I need to still go
into the dwo and save it...