Given this
MESSAGE statement
Use this statement to display a message.
Syntax
MESSAGE expression, ...
[ TYPE { INFO | ACTION | WARNING | STATUS } ]
[ TO { CONSOLE
Quote:
CLIENT [ FOR { CONNECTION conn-id [ IMMEDIATE ] | ALL } ]
[ EVENT | SYSTEM ] LOG }
[ DEBUG ONLY ] ]
|
What is wrong with this?
MESSAGE '{string}'
TYPE INFO TO EVENT LOG DEBUG ONLY;
The error message from ISQL that displays is as follows
This statement is inside a CREATE PROCEDURE STATEMENT
It works when TO EVENT LOG is changed to TO CONSOLE
or TO CLIENT however the messages viewable are limited
in volume by both the CONSOLE the ISQL results window.
ERROR MESSAGE
Could not execute statement
Syntax error near 'DEBUG" on line 21
SQLCODE=131, ODBC 3 State="42000"
file "{file name}.sql' on line 6, column 1
you can continue executing or stop.
One additional thing -- The registry entries still
correspond to the default settings referenced under
this item in the SQL Anywhere help file
event log, registry entry