Re: Need Locking Edification

Two comments: Firstly, "edification" does not mean "praise". Unless you're using the Devil's Dictionary, but I don't think even Abrose Bierce defines it that way. Neither my Webster's Unabridged nor my American Heritage has a definition of "edify" being anything close to "praise". edify - tr.v. - To instruct especially so as to encourage intellectual, moral, or spiritual improvement. Secondly, could just we stick to computers here? Alton B. Coalter wrote: > Cosmo Lee wrote: > > > > We're having a problem that when we are running deletes from a > table, > > users are locked out from completing Selects, and Inserts fail. We > > can't quite figure out why this happens . . . > > > > Two comments: firstly, "edification" means "praise." I think you > meant to use the word "clarification." > > Secondly, tables are created by default with page-mode locking > wherein a complete page is locked rather than an individual row. > If this is the case (use the -ss option of dbschema, for example), > then change it to row locking instead. > > -/Renegade -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *