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

Author: Ken Dibble

Posted: 2015-07-17 at 19:19:06

>procedure closeforsql

>lparameters thealias

>

> if type("alias(thealias)")#T_U

> use in (thealias)

> endif

>

> return

>

> endproc

This is kind of similar to what my query class does to clean up after

itself. However, my class keeps track of tables/work areas that were

open before the query was run, and only closes those that the query

itself opened.

It's interesting that you use a TYPE() check instead of USED(). Is

there some reason this was preferable?

Thanks.

Ken Dibble

www.stic-cil.org

_______________________________________________

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/50.BF.09593.55B99A55@cdptpa-oedge02

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