Cannot edit in grid using joined tables
Posted: 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.
This does not work:
This makes table editing all but useless, since I can't display any contextual information from other tables.
Can anybody help?
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.
Code: Select all
SELECT
ai.session_id
FROM
apnea_info ai
Code: Select all
SELECT
ai.session_id
FROM apnea_info ai
JOIN xtra_info xi on ai.id = xi.id
Can anybody help?