> I have 3 computers accessing a SQL-server at the same time. I > need the DB to be locked so they can't read/write the data at > the same time. How do I get the servers to "get in line" and > wait for each other?
Almost all databases provide that functionality automatically. If one database client is writing to the data, other database clients won't be able to read or write that data until the first one is done. If one database client is reading the data, other database clients won't be able to write that data until the first one is done. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists