HOW TO CHANGE DEFAULT QUERY in "Data" Tab

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

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
13 posts
[expired user #9879]'s profile image [expired user #9879] posted 8 years ago Permalink

sorry the image is this:

1 attachment(s):
  • borre
10137 posts
ansgar's profile image ansgar posted 8 years ago Permalink

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

13 posts
[expired user #9879]'s profile image [expired user #9879] posted 8 years ago Permalink
  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!!!

13 posts
[expired user #9879]'s profile image [expired user #9879] posted 8 years ago Permalink

bug report attached:

1 attachment(s):

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