Tab Names Incorrect With Multiple Queries

jplandry's profile image jplandry posted 9 years ago in General Permalink
I am on the current version (as of today) and connecting to a MS SQL server. When running multiple queries at one time, the TAB names seem to keep the name of the first table.

i.e.
SELECT * FROM ABC
SELECT * FROM DEF

Both tabs are showing up as 'ABC', instead of 'ABC', and then 'DEF'.

Thanks! I appreciate all of your hard work! :)
ansgar's profile image ansgar posted 9 years ago Permalink
Yes, that's a problem in HeidiSQL's query parser for MSSQL, which does its best to determine the name of the table by using the GetTableNameFromSQLEx() method. This is not working when you activate the option to send multiple queries in one batch. Only in MySQL mode HeidiSQL is doing the right thing here, as the MySQL library provides the table name together with the field objects after running a query. Sorry, I don't think this is doable in MSSQL.
jplandry's profile image jplandry posted 9 years ago Permalink
Thanks for the prompt reply. Have a great weekend.

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