Re: Starting transactions in 4.00

Joe Morris (jolomo@netcom.com) wrote: : Hi, we've recently decided to keep better tabs on who does : what and when in our databases. So I looked through the : manuals on accounting and transactions and I think transactions : would do just what we need. I'm using version 4.00.UE1 : It looks like a : START DATABASE dbname WITH LOG IN "here" : would start accounting but the manual says "No users can : access the database until you issue a CLOSE DATABASE statement" : So how would I begin database-wide transactions for all users? : Any info/pointers are begged for. : -- : -joe "Honey, they're in *everybody's* eggs" --firesigns The START DATABASE opens the database in exclusive mode; that's why nobody else can get in until you CLOSE DATABASE. But it only needs to be done once. After issuing START DATABASE, transaction logging is turned on permanently. You can change the log file name afterward, but you cannot turn it off (at least, not without dropping the database). -Jeff