SqlDbx
You are not logged in.
Pages: 1
Connecting to either SQL Server '05 and ASE 15, I don't see anything in the "Messages" tab.
Is there a way to get verbose messaging from the database for the query submitted.
i.e from Whistle ( a very old opensource ASE SQL client)
Thu May 21 11:44:34 2009>> Started
Thu May 21 11:44:45 2009>> Query:
select * from counters
Thu May 21 11:44:45 2009>> Open Client Message:
>> Message number: LAYER = (1) ORIGIN = (1)
>> SEVERITY = (0) NUMBER = (112)
>> Message String: ct_fetch(): user api layer: external error: 15 rows affected.
Thu May 21 11:44:45 2009>> End Query
Thanks,
Scott
Offline
Hi, Scott
The messages tab is for messages and errors.
So if there's no messages or errors there will nothing in it.
I am not sure what is the value of seeing all this information.
Are you seeing this message in this other program because there's an
error or it shows it all the time?
Offline
I think that is a nice feature request. Indeed status bar shows query status like "Query complete:<query>. However if you're running several queries as batch and they are insert/update/delete, it is impossible to see how many rows are affected by each and which of query is completed. It will be good to have as it is valuable information.
Offline
Two things you can do now.
1. Switch results from Grid to Text
2. When results set to Grid check "Include messages/errors" on a right click menu
This will not show query text, but maybe it's not a bad idea to add option to do that
Offline
Pages: 1