distal-attribute
distal-attribute
distal-attribute
distal-attribute

Grid Editing error

khanun posted 3 years ago in Running SQL scripts
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?
otomazeli posted 3 years ago
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?

mgmiles posted 9 months ago

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?

ansgar posted 9 months ago

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

select * from autoadmin_task_agents
mgmiles posted 7 months ago

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?

1 attachment(s):
  • grideditingerror

cibiz posted 6 months ago

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. :)

2 attachment(s):
  • heidisql1
  • heidisql2

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