You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Prabhakaran Duraisamy <pr...@formativesolutions.co.in> on 2009/10/07 09:19:17 UTC
To delete product
Hi,
How to delete a created product
--
Regards,
Prabhakaran.D
+91 99 520 93 900
Re: To delete product
Posted by Prabhakaran Duraisamy <pr...@formativesolutions.co.in>.
Thanks Pradeep,,,,
On Thu, Oct 8, 2009 at 11:26 AM, S K Pradeep kumar <
s.k.pradeepkumar@gmail.com> 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 <
> prabhakaran@formativesolutions.co.in> 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 <
> > s.k.pradeepkumar@gmail.com> wrote:
> >
> > > Try in EntitySQLProcessor
> > > With regards,
> > > S K Pradeep kumar,
> > >
> > >
> > >
> > > On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
> > > prabhakaran@formativesolutions.co.in> 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
Re: To delete product
Posted by S K Pradeep kumar <s....@gmail.com>.
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 <
prabhakaran@formativesolutions.co.in> 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 <
> s.k.pradeepkumar@gmail.com> wrote:
>
> > Try in EntitySQLProcessor
> > With regards,
> > S K Pradeep kumar,
> >
> >
> >
> > On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
> > prabhakaran@formativesolutions.co.in> wrote:
> >
> > > Hi pradeep,
> > >
> > > Where I Specify the Query to delete the product in database
> > >
> >
>
>
>
> --
> Regards,
>
> Prabhakaran.D
>
> +91 99 520 93 900
>
Re: To delete product
Posted by Prabhakaran Duraisamy <pr...@formativesolutions.co.in>.
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 <
s.k.pradeepkumar@gmail.com> wrote:
> Try in EntitySQLProcessor
> With regards,
> S K Pradeep kumar,
>
>
>
> On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
> prabhakaran@formativesolutions.co.in> wrote:
>
> > Hi pradeep,
> >
> > Where I Specify the Query to delete the product in database
> >
>
--
Regards,
Prabhakaran.D
+91 99 520 93 900
Re: To delete product
Posted by S K Pradeep kumar <s....@gmail.com>.
Try in EntitySQLProcessor
With regards,
S K Pradeep kumar,
On Wed, Oct 7, 2009 at 1:57 PM, Prabhakaran Duraisamy <
prabhakaran@formativesolutions.co.in> wrote:
> Hi pradeep,
>
> Where I Specify the Query to delete the product in database
>
Re: To delete product
Posted by Prabhakaran Duraisamy <pr...@formativesolutions.co.in>.
Hi pradeep,
Where I Specify the Query to delete the product in database
Re: To delete product
Posted by Prabhakaran Duraisamy <pr...@formativesolutions.co.in>.
Thanks Pradeep.. That is in Web tools ---> Entity SQL Processor
On Wed, Oct 7, 2009 at 12:52 PM, S K Pradeep kumar <
s.k.pradeepkumar@gmail.com> wrote:
> just don't assign it to any category if you don't want in the database
> delete using query.
> With regards,
> S K Pradeep kumar,
>
>
>
> On Wed, Oct 7, 2009 at 12:49 PM, Prabhakaran Duraisamy <
> prabhakaran@formativesolutions.co.in> wrote:
>
> > Hi,
> >
> > How to delete a created product
> >
> > --
> > Regards,
> >
> > Prabhakaran.D
> >
> > +91 99 520 93 900
> >
>
--
Regards,
Prabhakaran.D
+91 99 520 93 900
Re: To delete product
Posted by S K Pradeep kumar <s....@gmail.com>.
just don't assign it to any category if you don't want in the database
delete using query.
With regards,
S K Pradeep kumar,
On Wed, Oct 7, 2009 at 12:49 PM, Prabhakaran Duraisamy <
prabhakaran@formativesolutions.co.in> wrote:
> Hi,
>
> How to delete a created product
>
> --
> Regards,
>
> Prabhakaran.D
>
> +91 99 520 93 900
>