| Ani Nica 2005-04-13, 11:23 am |
| This is a bug related to the fact that a grouped query is used in the
MESSAGE statement. Thank you for reporting it. A work around is to compute
the grouped query outside the MESSAGE statement. E.g.,
create variable X int;
set X = (SELECT count(*) FROM sysevent);
MESSAGE 'records count in SYSEVENT ' || X
--
Ani Nica
Research and Development, Query Processing
iAnywhere Solutions Engineering
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"Alexander Goldun" <alexgold@spamtest.ru> wrote in message
news:425d0240@forums
-1-dub...
> ASA 9.0.2.2551 Developer Edition under win2000 srv
>
> The statement:
>
> MESSAGE 'records count in SYSEVENT ' || (SELECT count(*) FROM sysevent)
>
> raises error: Syntax error or access violation: Invalid use of an
> aggregate function
>
> But in ASA 8.0.3.5144 it works correctly
>
> --
> With best regards,
> Alexander Goldun
|