Delete all recipes at once

A forum devoted to the discussion of all topics having to do with scripting and other advanced programming using iX Developer.
Post Reply
JohnCZ
Posts: 73
Joined: Wed Jun 27, 2012 1:17 am
Location: CZ
Contact:

Delete all recipes at once

Post 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

mark.monroe
Posts: 824
Joined: Tue Mar 13, 2012 9:53 am

Re: Delete all recipes at once

Post 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 7798 times
Best Regards,
Mark Monroe

Beijer Electronics, Inc. | Applications Engineer

JohnCZ
Posts: 73
Joined: Wed Jun 27, 2012 1:17 am
Location: CZ
Contact:

Re: Delete all recipes at once

Post 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

Post Reply