First off I am sorry for my english grammar. I will try to describe my problem as clearly that i am able to.
I have a table which consists of two columns the first column consists of a
varchar as data type called "NAME" and the second has a BOOLEAN as a data type the later column is called "DELETEABLE".
I have values stored in this table which are of a default nature and are meant to be undeleteable by the user.
All theese values which are defaults is stored with the value deleteable set to false in the boolean column which means that the user
can on only delete records with values set to true in the recently mentioned location. New entries have "DELETEABLE" values set to true.
Before new records are inserted the insert query must first check if the value that are to be inserted exists or not. Sorry if i don't
have any code to provide as an example on how far i have gotten in this matter.
I am a beginner at sql and have a very basic knowledge but i am learning more and more. I hope I have been clear and not
too complicated. All help and hints are very much appreciated in advance!