Hello again people.
I have a problem.
Think of a textarea. The text area is filled with information depending on an entrance in a textbox.
Like userID is entered and the information is filled in the textarea.
I want the user to edit the textarea. But when he is editing, the information are called important and umimportant data. Important data is not to be edited. Unimportant data can be edited.
So i have 2 textareas first one is editable and the second one is noneditable.
To continue to my problem, i want to say this. The unimportant and important data is mixed in the database. The first record is UNIMP the second is IMP the third IMP the fourth UNIMP exc.....
What i want to do is allow user to edit the unimportant data which is in the editable text area. Also after the updating, i want the unimportant to be the first records of database. So when i handle with this problem;
User enters a userID and clicks a button.
Information(a and b) is filled in a text area.
a is unimportant and b is important.
Information a is edited.
User clicks "update" button
The rows regarding to previous a and be is deleted.(query1)
textarea of UNIMP data is inserted and textarea of IMP data is inserted(query2)
What i am afraid is what if something happens between query1 and query2.
The important data might be deleted and never come back.
Note: Data is recorded in the database with white space characters.
For example;
Hello. I don't like my name.
But i like the way i look.
This is recorded as
Row1-Hello. I don't like my name.
Row2-
Row3-But i like the way i look.
in the database
CAN A STORED PROCEDURE PREVENT WHAT I AM AFRAID OF?