Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

It has taken most of a day to boil this [cough] phenomenon down into a simple reproducible...

Why does the line "152 row(s) affected" appear in the results tab when I run the following script in ISQL 17.0.9.4882 on an empty database?

MESSAGE STRING ( '****************************** CREATE EVENT rroad_purge' ) TO CLIENT;

BEGIN
   DROP EVENT rroad_purge;
   EXCEPTION WHEN OTHERS THEN
END;


-------------------------------------------------------------------------------------------------------------------------------------------------
CREATE EVENT rroad_purge
HANDLER BEGIN

END;

It has something to do with the line of dashes, but why? ...this has never happened before.

alt text

asked 02 Jan '19, 14:41

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 02 Jan '19, 14:43

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×46

question asked: 02 Jan '19, 14:41

question was seen: 1,051 times

last updated: 02 Jan '19, 14:43