Page 1 of 1

Delete all recipes at once

Posted: Wed Sep 11, 2013 4:46 am
by JohnCZ
Hello all,

just question is there a way to delete all RuntimeData in Recipe at once ?? Because we are saving recipe continuously on TagNumbers so then we don't know the name of the Recipes. Name of the recipes are numbers from the tags. We want time to time to deleted all RuntimeData.Without to show Dialog with All Runtime Data where we must select one and then click Delete. Just want to delete all Runtime Data in Recipe1 on button click..

Thanks
JohnCZ

Re: Delete all recipes at once

Posted: Wed Sep 11, 2013 9:01 am
by mark.monroe
Recipes are stored in a database. The only way to do what you want is to write a SQL delete query and delete the recipes that you do not want directly out of the database. This forum post has an example script that shows you how to query a datalogger table in the database. The Recipe data is stored in the same database, but under a different table name. You can use the iX Dev database viewer to view what is in your recipe table on the HMI during runtime.
Snap 2013-09-11 at 08.59.42.jpg
Snap 2013-09-11 at 08.59.42.jpg (75.1 KiB) Viewed 7804 times

Re: Delete all recipes at once

Posted: Fri Sep 13, 2013 12:58 am
by JohnCZ
Thank you.

That was the problem. I didn't know what was the name of the table in Database.sdf. Request solved.

JohnCZ