[RESOLVED] row lock

Hi ,

I want to connect to a database and update a certain row .. then lock it.

when trying to access the row again I want to prompt the user he cant because its locked..

thank you in advance..

Add field called Updated.

Before allowing any updates to the record, check the field. If it is empty, allow the update.

After the first update, put "Yes" in that field.

Now, the next time someone goes to update that record they won't be able to because of their field entry.

But, then again, you wouldn't be able to update it either.

No one could.

Is that what you want?

thank you HACK,

are you telling me to add a column to every row holding a boolean value telling if the row has been updated or not?

I'm saying add a field to your table.

thank you hack

You are welcome. :)

If you consider this resolved, you could help us out by pulling down the Thread Tools menu and click the Mark Thread Resolved menu item. That will let everyone know that you have your answer.

Thank you. :)