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

Author: Ken Dibble

Posted: 2015-07-17 at 20:22:23

>He's really parameter checking with that TYPE test, not checking

>that the alias is USED.

Exactly. But if the alias is not USED(), then he assumes its TYPE()

will be "U" so he doesn't have to close it. And I believe it works

without having to address work areas, at least within the current

datasession. I'm not sure it would work across datasessions though,

but it's an interesting alternate approach.

Ken

_______________________________________________

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/47.80.11266.B2AA9A55@cdptpa-oedge03

** 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 Ken Dibble