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

It appears that by default the MESSAGE TO CLIENT output is sent to the History tab along with all the SQL statement history, thus rendering the SQL Anywhere 17 dbisql utility unusable IMO.

Is there any way to restore the SQL Anywhere 16 behavior?

asked 26 Apr '16, 16:21

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

v17's dbisqlc is not option for you, right?

(I still use it in parallel with DBISQL, so I'm not sure whether my suggestion is more than silly...)

(27 Apr '16, 15:59) Volker Barth

A late reminder: Do we have to take the v17 design as given, or is there hope that this undesired behaviour change could be reverted/opted-out in coming releases?

As discussed here, it's not only disadvantageous for MESSAGE statements but also for statistics/row counts...

(Sorry for using an answer for what is certainly a question - but I hope to get more visibility that way than when using just another nested comment...)

permanent link

answered 19 Jan '17, 12:10

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 19 Jan '17, 12:12

Short of using version 16 dbisql I don't see such an option.

The messages tab was removed entirely from version 17.

permanent link

answered 26 Apr '16, 17:18

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%


But why? It's a good idea to have a history of the messages, no doubt. But when you have a lot of instrumented code and you are testing procedures, the output squeezed into a cell in the history tab is a nightmare. We should have the option to receive the running messages in a separate tab, too.

(27 Apr '16, 08:20) Michael Fischer
Replies hidden

> The messages tab was removed entirely

That certainly violated The Watcom Rule.

(27 Apr '16, 15:50) Breck Carter

Looks like someone forgot, that there are real users in the world outside using (and paying for) that product.

(28 Apr '16, 04:31) Reimer Pods
Replies hidden

We should have the option to receive the running messages in a separate tab, too.

I fully second that suggestion.

As a workaround, it might help to add a further option for the History Results "Show" combo box to just list the messages instead of the issued SQL...

(28 Apr '16, 06:51) Volker Barth
Comment Text Removed
Comment Text Removed

It really wouldn't take much time to ask for opinions ahead of such a drastic change... it doesn't have to be an expensive formal "focus group" or "customer advisory board" process, just a few friendly email conversations. That's what I do with Foxhound, and it has saved me from mistakes every bit as awful as the Cockpit :)

(28 Apr '16, 07:51) Breck Carter

Well, that's the consequence of not offering a beta version anymore, I suspect...:(

(28 Apr '16, 07:55) Volker Barth

Beta testing comes after decisions have been made, features have been frozen and the money's been spent. I prefer to avoid mistakes before sounding the horn, Let The Waste Begin! :)

(28 Apr '16, 16:34) Breck Carter

Sure, but correcting issues during beta tests is still less expensive (or possibly more likely) than during maintenance...:)

(28 Apr '16, 17:03) Volker Barth

OK... don't get me started talking about the useless beta process.

(29 Apr '16, 08:00) Breck Carter
showing 3 of 9 show all flat view

In DBISQL 17, the "Messages" tab was combined with the "History" tab. Text from a MESSAGE TO CLIENT statement shows up there, next to the MESSAGE statement itself.

permanent link

answered 27 Apr '16, 07:51

ChrisIrie's gravatar image

accept rate: 33%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 26 Apr '16, 16:21

question was seen: 3,685 times

last updated: 19 Jan '17, 12:12