Emaze Auction: Delete Category

You did not choose the category to delete.

SELECT categoryID FROM Category WHERE categoryID <> #categoryID# AND (categoryID1 = #categoryID# OR categoryID2 = #categoryID# OR categoryID3 = #categoryID# OR categoryID4 = #categoryID#)

This category has at least one subcategory. You may not delete a category which has subcategories. You must delete the subcategories first.

 SELECT lotID FROM Lot WHERE categoryID = #categoryID#

This category has at least one lot. You may not delete a category which has lots. You must delete the lots first.

 SELECT categoryID, categoryName, categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID = #ListGetAt(categoryID,1)# OR categoryID = #catCount# ORDER BY categoryName

DELETE FROM Category WHERE categoryID = #categoryID# DELETE FROM CategorySubscribe WHERE categoryID = #categoryID# Category #categoryName# deleted