> okey Arda, think of it, assume I have two user, one record with id=110, if
> both of them try to delete it at the same time, one of them will delete

and

> the other will not see that it deleted since he did not refreshed the
> dataset yet,

>And as far as i remember he'll get some error like " another user has

changed/deleted the record"..
Who commits first wins.. Interbase works like this..
Bu if you really want to lock a record while editing, you might try using
IBObjects to achieve this..

>I think there will be a problem because ..

This will only be a warning..