exception error when SQL query return more than one table

[expired user #9256]'s profile image [expired user #9256] posted 8 years ago in General Permalink

HeidiSQL is connected to an MS SQL-server and generally works flawlessly.

Since version 9.3.0.5062 I get exceptions errors when the SQL query or stored proc returns multiple result tables (e.g. sp_help tablename). Upgrading to version 9.3.0.5063 did not help.

It seems to be a bug; I am willing to provide more information if needed

1 attachment(s):
[expired user #9256]'s profile image [expired user #9256] posted 8 years ago Permalink

I forgot to mention that the problem may have started with build 5062, but could have started earlier. I don't download every new build and 5062 was the first where the problem occurred.

Before, queries with more than 1 result table led to multiple tabs in the result pane.

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5064
MSSQL: Work around multiple results from a single query, in case of a stored procedure for example. See http://www.heidisql.com/forum.php?t=21036
ansgar's profile image ansgar posted 8 years ago Permalink

Thanks for the hint. I guess I did not think about procedure with multiple results when splitting SQL queries for getting the table name into the grid export. See http://www.heidisql.com/forum.php?t=20979

r5064 now does a safety check before running into that exception.

[expired user #9256]'s profile image [expired user #9256] posted 8 years ago Permalink

I confirm my problem is solved with 5066. Thank you for your fast help :-)

Please login to leave a reply, or register at first.