Bug: Cannot open views/stored procedures from search sidebar

[tstrilch]

Describe the bug

Describe the bug
Using the right click to load SQL for any View or Stored Procedure from the search sidebar does not work in Version 2026.62 (Build 111199) they way it worked in Version 2026.26 (Build 111181). I have multiple databases on the server that I am connecting to and it appears that when I use the search sidebar and right click to view the contents of a View or SPROC it opens an empty tab and appears to show a connection to the first alphabetical database on my server instead of the database the SQL was located in. If I use the search sidebar to find something within that first database, it works fine. Based on that, I'm assuming it's simply not passing through to the new tab which database it is looking for the SQL in.

To Reproduce

1. Connect to DB Server
2. Choose any View / SPROC in sidebar
3. Right click and select Alter View / Modify
4. SQL appears in new tab
5. Use search feature in sidebar to find View / SPROC
6. Right click and select Alter View / Modify
7. New empty tab appears

Expected behavior
Previous versions of the app would load the SQL in a new tab (connected to the proper database)

Screenshots

The screenshots show the right click menu option for the default sidebar vs. the search sidebar.

Product

SQLPro Studio

App version

Version 2026.62 (Build 111199)

Platform

macOS

Installation source

Website download

[hankinsoft]

Which type of database are you trying to use this with? I've been unable to reproduce so just trying to figure it out. And you just get a completely empty tab when you 'alter view' on the new version? No error or anything?

[tstrilch]

I'm connecting to a SQL Server database, but the main issue is that I have multiple databases hosted on the same server. So when I connect, I only connect to the server and don't choose the option database. If there were 3 different databases on my server (DB1, DB2, and DB3) and they appeared in that order... the Alter View / Modify only fails when I'm trying to access a View or SPROC in DB2 or DB3 in which case it opens a new tab with DB1 pre-selected. If I try to alter/modify something in DB1, it doesn't have issues (I'm assuming because it's always defaulting to the first DB in the list). Hopefully that helps.

[hankinsoft]

Reproduced. I see a couple things going on here so I am investigating further.

[hankinsoft]

Hi. Could you please try this build:
https://sqlprostudio.s3.us-east-1.amazonaws.com/studio/SQLProStudio.2026.84.app.zip

And see if that sorts things out?