Yes - I was VERY Afraid to read your RTF. Although - maybe just nit picking - but, you should not have put a black in the file name - as it comes up in this forum thread as an incomplete link - and a bad link if you click on it. But, no biggie - I just cut&pasted the whole thing.
Wow - it sure is a LONG Read - but its understandable since its also a lot of Code in the RTF. And, you sure do put a lot of comments - although - that's surely not a bad thing. I try to put more comments in code - especially if its some tricky logic I am implementing. Will continue to peek at your RTF now... -K- -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Thursday, July 16, 2015 12:20 PM To: profoxt...@leafe.com Subject: Re: "File In Use" on USE "during" SQL SELECT Execution >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. Yup. But my code never sets up ALIASes that are different from the table name. I'm about to post a very long message providing excruciating detail about this. Be afraid. Be very afraid. Thanks. Ken [excessive quoting removed by server] _______________________________________________ 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/80838f1ca795b14ea1af48659f35166f1cd...@drexch02.corp.globetax.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.
