Cannot update data grid when query contain substring or truncate function
Im trying to update the data in the data grid after running a query, but it still indicates it is Read Only. The Updateable button is turned ON. The query contains a substring and truncate function. However as soon as they are removed or commented out then I can update the data grid.
Why cant I update data when a query contains substring or truncate functions with the query?
This is as designed. Data grid does not support queries with built-in function in the queries. Please Online Help for more information:
Restrictions for updateable queries:
* The SELECT statement must be a simple SELECT statement (no joins, sub-queries in select clause, calculated fields, group by, having, count(), substr or DISTINCT).
* You must have the appropriate privileges to update the table or view.