Thanks Pradeep,,,, On Thu, Oct 8, 2009 at 11:26 AM, S K Pradeep kumar < [email protected]> wrote:
> 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 > > > -- Regards, Prabhakaran.D +91 99 520 93 900
