Works fine if you're hitting a VFP back end. Note the DELETED() function as well.
I'd wrap the whole shutdown bit in a TRY..CATCH. I've found that the EXCEPTION object can often give you more helpful info. Or perhaps separate TRY..CATCHs around the critical tasks. For example, if the problem is really related to PACKing this table, do you really care if it happens every time? If the PACK is failing for environmental reasons, say an AV realtime scan locked the table at the exact moment you tried to PACK it, then the next time your app exits it won't fail and the table gets PACKed and everyone is happy. -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Fred Taylor Sent: Tuesday, July 30, 2013 12:26 PM To: [email protected] Subject: Re: Indecipherable VFP Error 2115 You can't use ANY VFP function that requires an alias as a parameter in a SQL statement. You're using "... EMPTY(dicttable)" which is a big no-no. Fred On Tue, Jul 30, 2013 at 8:17 AM, Ken Dibble <[email protected]> wrote: > This thing is driving me nuts and I'm hoping someone will see a > glimmer of sense in it. _______________________________________________ Post Messages to: [email protected] 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/DF1EEF11E586A64FB54A97F22A8BD04422846D55B9@ACKBWDDQH1.artfact.local ** 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.
