hi , i am using forms 6i ,
i created a form with a block based on a ( From Clause ) ,
the query is :
SELECT I.ITEM_ID , S.ITEM_ENG_NAME , S.ITEM_ARABIC_NAME , SUM(I.QUANTITY) QTY , I.MAX_TO_MIN_FACTOR , I.MIN_UNIT ,
I.PACKET_SELL_PRICE
FROM ITEM_DETAIL I , STOCK S WHERE I.ITEM_ID = S.ITEM_ID
GROUP BY I.ITEM_ID , S.ITEM_ENG_NAME , S.ITEM_ARABIC_NAME , I.MAX_TO_MIN_FACTOR , I.MIN_UNIT , I.PACKET_SELL_PRICE
ORDER BY S.ITEM_ENG_NAME
the query runs successfully in sql developer ,
when i try to change a value on any updatable item , i get the above errors ( unable to reserve records for update or delete , and when display error , i get invalid table name ) .
?