On 5/11/2012 5:56 PM, Tracy Pearson wrote: > MB Software Solutions, LLC wrote on 2012-05-11: >> On 5/11/2012 5:25 PM, Tracy Pearson wrote: >> Michael Madigan wrote on 2012-05-11: >>>> Use database shared noupdate >>>> Use database noupdate >>>> >>>> Are these statements logically identical? >>> >>> Michael, >>> >>> Doesn't this depend on the SET EXCLUSIVE setting? >>> >> The clause you specify would override the SET EXCLUSIVE setting, >> wouldn't it? >> > > Mike, > > Testing shows that when EXCLUSIVE=ON, the table is opened exclusive, when > the SHARED clause is not used.
Yes, but in his example, he didn't combine EXCLUSIVE and SHARED; he used SHARED and NOUPDATE. So with EXCLUSIVE ON and him specifying SHARED in the clause, it would be opened not exclusive but SHARED. Right? Or am I seeing this wrong? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
