I do not agree with your comments. The proof I care about users is that I'm here every days, including for you! Secondly, only two users have a problem with this feature. Dimitris and you. Dimitris choose to implement his hown way in a customized version.

Now, let me resume:

1. I can display the current error message. In this case, you have two solutions:
   1. Check "Archived" for the category, the more simple and safe way.
   2. Change the category for all sub categories and products linked to the category you want delete. This can be very long and annoying, but it work and it's safe.
2. I can hide the SQL error part of the message if you don't like it.
3. I can flag as "IsDeleted" a category when a user click on Delete and confirm. In this case, if you have dozens of sub cateories and thousand products, they will be no longer available! But still in the database. IMHO this way can be very dangerous.

If you have a better solution do not hesitate to propose. I'm open minded to every constructive solution!

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

I have made a lot of changes this week-end on how the products and categories must be deleted. In the next version, a product will be realy deleted if it's not used by an order. A category will be realy deleted if none sub categories and products are linked. In all other cases, the product/category will be marked "IsDeleted".

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

We had a conference call yesterday with Will and Benoît, I think of delivering the next version in two weeks surroundings. Then, it will be submitted to the release process. Because neither Will, nor me have control on this stage I cannot give you a precise date.

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.