What's New in SQL Anywhere Studio
What's New in Version 7.0.2
Behavior changes in version 7.0.2
The following are behavior changes from previous versions of the software.
Aliases must be defined before first reference In earlier versions of SQL Anywhere, it was possible to refer to an alias in a SELECT list before the definition of the alias had appeared. An attempt to do so will now generate the error "Definition for alias alias-name must appear before its first reference". To prevent this error, the SELECT list must be re-ordered so that the alias definition appears before its first use.