Hi all
I have an editable IG built from a query as follows:
I have hidden the checkbox and some columns and made one item a select list and one a Modal LOV and added a DA to refresh after Save.
My IG displays as follows:
I seem to get Insert/Update working fine and then without significant change I get the following for any operation on the IG
Ajax call returned server error ORA-20987: APEX - Process 'New - Save Interactive Grid Data' raised 'ORA-01733: virtual column not allowed here' while executing a DML command. This error can occur if a column is based on an aggregation or SQL expression. Set column attribute 'Query Only' to Yes to exclude the column from the INSERT and UPDATE statement. - Contact your application administrator. for .
I assume it is because I have made select list/LOV - but it was working fine at one point - any ideas?