Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to detect table #3272

Open
haykoyk opened this issue Apr 11, 2024 · 5 comments
Open

Unable to detect table #3272

haykoyk opened this issue Apr 11, 2024 · 5 comments

Comments

@haykoyk
Copy link

haykoyk commented Apr 11, 2024

  1. Microsoft SQL Server
  2. Version 5.9.6 (546). MacOSX

For instance I have a query SELECT * FROM Marketplace.ConnectionEntity WITH(NoLock) where Id = 329;
When I open TablePlus my environment is opened and also my Tabs where this query is.
The first time I execute it I can not edit field. Neither in the grid or right side bar.
Then I change the Query by typing again Marketplace.ConnectionEntity (the same and with the right cases) and execute the query and no I can edit the data everywhere. In other cases this is also a problem. You need to seriously look into this please,
because the last versions its buggy and doesn't work properly. Editing is just one of the major feature I use for my environment though.

Thank you!

@haykoyk
Copy link
Author

haykoyk commented Apr 11, 2024

I reverted back to Version 5.9.0 (538) and every query even combinations like these
SELECT top(500)Description, ShopId, * FROM Marketplace.ConnectionEntity WITH(NoLock) WHERE Description LIKE '%xxx%'
work properly! So it's definititely something wrong in the latest versions.

@huyphams
Copy link
Contributor

You may disable this feature on the newest release and it should work, I think
Screenshot 2024-04-11 at 3 46 51 PM

@haykoyk
Copy link
Author

haykoyk commented Apr 11, 2024

Thank you this works with the latest version :-) But maybe this should be disabled by default because people are used to certain functionality and they don't know how to find this option. I also searched for the sliders button to get these options :-)

Thank you for your quick answer. You can close this.

@robertn702
Copy link

robertn702 commented Apr 18, 2024

@huyphams I am getting the same error and I'm not seeing a settings option in the context menu. I'm connect to a libSQL db and am on version Version 5.9.7 (547).

image

edit: I am getting this error when trying to edit a column from a simple select statement (e.g. SELECT * FROM table LIMIT 1000)

@huyphams
Copy link
Contributor

it's fixed on the latest release @robertn702 thanks for letting me know

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants