Locking rows?

[dspeer]

I have a little script running that performs the following functions:
-flush the contents of tblFTPLog
-download a log file from our company's FTP server
-LOAD DATA on this file pushing it into tblFTPLog
-a query runs that joins the tblFTPLog with tblFTPStatus, which contains status information for jobs in tblFTPLog.
-fills in a table with these results and allows you to change the status of each file and add comments.

The tblFTPLog contains ALL log entries from the FTP server. I only look at the ones which show files sent. My employees in the data center view one version of the script that allows them to edit and update status entries. The remote print sites will use another version that only allows them to see which files have come in. My problem, however, occurs when two data center employees edit at the same time. We are testing this script for implementation soon. Is there a way I can lock down rows or keep errors from occuring this way? Can I make them run linearly and not concurrently? Any help would be appreciated. Thanks!

[eoghain]

Depending on your database you should have access to various locking mechanisims. Check the documentation for Row Locking, Transactions (Begin, Rollback, Commit), Table Locking, Select For Update. These are all items that allow some form of locking.