Re: "File In Use" on USE "during" SQL SELECT Execution

Author: Ted Roche

Posted: 2015-07-16 at 09:57:11

On Thu, Jul 16, 2015 at 9:21 AM, Ken Dibble <krdibble@stny.rr.com> wrote:

>

>

> However, I have also seen this before, rarely, in other situations:

>

> IF NOT USED("mytable")

> USE mytable IN 0 && Error 3; File in use.

> ENDIF

>

USED() only tells you if an ALIAS name is used, not a table.

create table temp (field1 c(10), field2 d)

USE

use temp alias nottemp in 0

? used("temp") && .F.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CACW6n4sgQyBhLkJdmcvf2NYeh0adZ7WLVS6mBKoo=eXLGQs29Q@mail.gmail.com

** 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.

©2015 Ted Roche