In SQL Anywhere 10, the word “window” is a reserved word. As a result, SELECT statements on a column with the name window do not work correctly. There are several ways to work around this issue:
Set the DelimitIdentifier database parameter to “Yes” in the ConnectString.
Set the SQL database option “SET OPTION NON_KEYWORDS = ‘WINDOW’”.
In SQL statements, enclose the column name in quotation marks.
[CR 334166]
