Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

HOW TO CHANGE DEFAULT QUERY in "Data" Tab

marce002 posted 3 years ago in General

Hello

Is there any way to change the automatic query generated by heidi, when you click in DATA tab, for any table? I m having trouble with data displaying for some of the tables, while others work fine...

Those tables with trouble says:

1 attachment(s):
  • borre
marce002 posted 3 years ago

sorry the image is this:

1 attachment(s):
  • borre
ansgar posted 3 years ago

Please post the query text here, and some version details about your server.



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
marce002 posted 3 years ago
  1. SQL VeRSION is: 8.00.2055 SP4 Enterprise Edition
  2. Windows Authentication is used
  3. Last heidi version is used: 9.30.5086
  4. "data" is not available for any table but I can see the TREE correctly
  5. I've expected the DATA button to simply do a select top 1000 * from tablename, but it is more complex than, that...wonder if can this be changed somehow..
  6. I think Some settings at server might be in SPANISH i do not administer that.

thanks!!!

marce002 posted 3 years ago

bug report attached:

1 attachment(s):

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