Cannot update data grid when query contain substring or truncate function (4230192)

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.