Cannot edit in grid using joined tables

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
CraigF
Posts: 1
Joined: Fri 12 Mar 2021 19:26

Cannot edit in grid using joined tables

Post by CraigF » Fri 12 Mar 2021 19:49

Editing data in the grid works correctly when retrieving data from a single table.

The documentation states that the product allows editing joined tables by choosing which table to edit from the drop-down table menu.

However, as soon as I add a join, the grid goes into read only mode, and the table drop-down does not show any table names. This happens even if I don't select any fields from the second table.
  • I tried changing paginated mode, and that makes no difference.
  • I tried different ways of specifying the join, and that makes no difference.
  • It doesn't matter whether I select a single column or all columns.
This works:

Code: Select all

SELECT 
   ai.session_id
FROM 
  apnea_info ai
This does not work:

Code: Select all

SELECT 
   ai.session_id
FROM apnea_info ai
JOIN xtra_info xi on ai.id = xi.id 
This makes table editing all but useless, since I can't display any contextual information from other tables.

Can anybody help?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Cannot edit in grid using joined tables

Post by dzhanhira » Thu 18 Mar 2021 07:55

Do you use Studio? Which version?

Post Reply