Kishor, >Hi, > >We are trying to implement row level locking in our appln. >we have a table Orderwe are locking the table using >SELECT * FROM Order FOR UPDATE; >but still another user is able to update this table. ........why?
check with mysql>SHOW TABLE STATUS FROM yourdatabasename; that your table really is InnoDB type. >we have autocommit set to zero.Our requirement is >1. user selects a order for editing. >2. then another user should not be able to edit this order.any ideas? >thanx in advance > >kishor Regards, Heikki --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php