Delete all demo things

[ladroge <la...@hotmail.fr>]

Hi 
I want to delete all demo product.
I think that the script on sourceforge.net named delete-everything delete
only some tables content.
I wanto perform this script but someone can explain me the command line :

delete from shipment_receipt where 1=1;

I want to understand the clause where 1=1;

Thanks 
-- 
View this message in context: http://www.nabble.com/Delete-all-demo-things-tp16025512p16025512.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Delete all demo things

[BJ Freeman <bj...@free-man.net>]

if you are using the derby db then do a ant clean-data which basically
deletes the DB and  "run-install-seed" ant task rebuilds it from seed data
if you using an external DB you will have to purge the DB for the DB
admin then  "run-install-seed" ant task

The "run-install-seed" ant task will not remove demo data.


ladroge sent the following on 3/13/2008 7:04 AM:
> Hi 
> I want to delete all demo product.
> I think that the script on sourceforge.net named delete-everything delete
> only some tables content.
> I wanto perform this script but someone can explain me the command line :
> 
> delete from shipment_receipt where 1=1;
> 
> I want to understand the clause where 1=1;
> 
> Thanks 

Re: Delete all demo things

[Roberto Cosenza <ro...@infoflexconnect.se>]

I don't know why it is there. it is probably an implementation issue.
But since 1 is always equals to 1 it will delete all the entries from  
the table shipment_receipt
/roberto

On Mar 13, 2008, at 4:04 PM, ladroge wrote:

>
> Hi
> I want to delete all demo product.
> I think that the script on sourceforge.net named delete-everything  
> delete
> only some tables content.
> I wanto perform this script but someone can explain me the command  
> line :
>
> delete from shipment_receipt where 1=1;
>
> I want to understand the clause where 1=1;
>
> Thanks
> -- 
> View this message in context: http://www.nabble.com/Delete-all-demo-things-tp16025512p16025512.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Re: Delete all demo things

[Raj Saini <ra...@gmail.com>]

/ /I think the script you are talking about is Opentaps.

In Ofbiz, you just do not load demo data instead of deleting it. Run the 
"run-install-seed" ant task instead of "run-install". It will only load 
your seed (minimal data required for Ofbiz to work) and no demo data.

Raj

ladroge wrote:
> Hi 
> I want to delete all demo product.
> I think that the script on sourceforge.net named delete-everything delete
> only some tables content.
> I wanto perform this script but someone can explain me the command line :
>
> delete from shipment_receipt where 1=1;
>
> I want to understand the clause where 1=1;
>
> Thanks 
>