MySQL Forums
Forum List  »  Newbie

Locking Records
Posted by: donw
Date: August 03, 2005 02:29PM

Hi All,


I need to write an explode routine to be used with a scheduling application. The processing step will be as follows:

First lock a record in one table to signify this routine is in use.

Build a temp table with load records showing what's booked and by who.

Once I've checked the temp table and verified time's available for my booking then write a new load record.

Unlock the record signifying use to others.


I've written this with Visual Foxpro and want to do the same web based. I'm unsure how I do a pessimistic type lock with mysql.


thanks,

Options: ReplyQuote


Subject
Written By
Posted
Locking Records
August 03, 2005 02:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.