distal-attribute
distal-attribute
distal-attribute
distal-attribute

exception error when SQL query return more than one table

Dnk1287 posted 1 year ago in General

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):
Dnk1287 posted 1 year ago

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.

ansgar posted 1 year ago

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.

Dnk1287 posted 1 year ago

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

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