delete from `PRODUCT_KEYWORD` where `PRODUCT_ID`='SP-1000'; delete from `PRODUCT_CALCULATED_INFO` where `PRODUCT_ID`='SP-1000'; delete from `PRODUCT_PRICE` where `PRODUCT_ID`='SP-1000'; delete from `INVENTORY_ITEM_DETAIL` where `INVENTORY_ITEM_ID` IN (SELECT `INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000'); delete from `INVENTORY_ITEM_VARIANCE` where `INVENTORY_ITEM_ID` IN (SELECT `INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000'); delete from `SHIPMENT_RECEIPT` where `INVENTORY_ITEM_ID` IN (SELECT `INVENTORY_ITEM_ID` FROM `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000'); delete from `INVENTORY_ITEM` where `PRODUCT_ID`='SP-1000'; delete from `PRODUCT_CATEGORY_MEMBER` where `PRODUCT_ID`='SP-1000'; delete from `PRODUCT` where `PRODUCT_ID`='SP-1000';
With regards, S K Pradeep kumar, On Thu, Oct 8, 2009 at 10:32 AM, Prabhakaran Duraisamy < [email protected]> wrote: > Hi pradeep > > I specify the Query to delete product in Entity SQL Query, there is error > report of foreign Key .Can you help me with Query > > Thanks > D.Prabhakaran > > On Wed, Oct 7, 2009 at 2:42 PM, S K Pradeep kumar < > [email protected]> wrote: > > > Try in EntitySQLProcessor > > With regards, > > S K Pradeep kumar, > > > > > > > > On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy < > > [email protected]> wrote: > > > > > Hi pradeep, > > > > > > Where I Specify the Query to delete the product in database > > > > > > > > > -- > Regards, > > Prabhakaran.D > > +91 99 520 93 900 >
