Grid Editing error

When running code similar to this one

select *
from employee
where technician_no = '12345';

I get a table with my selected items. No surprises so far - but if I try editing any of the fields, I get a

Grid Editing error
Could not find table or view mydatabase.employee.
Please refresh database tree.

How come?

I'm having same issue always happening when returning record from select and double clicking in any grid cell

[Window Title]
Error

[Main Instruction]
Grid editing error

[Content]
Could not find table or view Inventory.tblGlTransactions. Please refresh database tree.

[OK]

[Footer]
Find some help on this error

When running code similar to this one

select *
from employee
where technician_no = '12345';

I get a table with my selected items. No surprises so far - but if I try editing any of the fields, I get a

Grid Editing error
Could not find table or view mydatabase.employee.
Please refresh database tree.

How come?

When running code similar to this one

select *
from employee
where technician_no = '12345';

I get a table with my selected items. No surprises so far - but if I try editing any of the fields, I get a

Grid Editing error
Could not find table or view mydatabase.employee.
Please refresh database tree.

How come?

I have just started using Heidi SQL and have hit this problem using SQL Server. 2 years with no response though makes me wonder if I have selected the wrong product.

Does anyone have a solution to this problem?

I just made a quick test, not getting that error. I was firing this query within msdb:

select * from autoadmin_task_agents

I am still getting that error when double-clicking in a cell on a simple query like select * from applications (see attachment)

Do you need any more details to help track down this error?

Hi @ansgar,

I also facing this same problem. Really hope that you can help fix this.

I think the problem came from the OWNERS of table in Database. Please refer attachment below.

You can see that the full schema is:

IJPNCMN.IJPN.staff_session

In this IJPNCMN database, I'm using IJPN as owner of table staff_session. The "Grid editing error" shows that MISSING owners of IJPN in this case. Which is i assume that it looking for .dbo as default owner of the table.

IJPNCMN.??.staff_session

I'm using MSSQL Server 2008 R2. Hope this helps. :)

Just bumped onto this one.

Server: Microsoft SQL Server Standard (64-bit) 12.0.2000.8 Heidi: 9.4.0.5125 (64bit) Client: Win 10 x64

Query:

SELECT * FROM dbo.TableName where Column=123