On Wed, May 27, 2009 at 11:57 AM, Ken Dibble <[email protected]> wrote: > Hi all, > > My VFP 9 SP 1 program, which has been in use for well over 3 years in a > multi-user LAN environment where the application runs on the workstation > (Windows 2000 Pro) and accesses VFP tables stored on a Linux server > (CentOS) via SAMBA, with OPLOCKS off, suddenly turned up this error while > executing a SQL SELECT command: > > Error 2115: "Execution of function or command is not allowed in context of > SQL command" >
Ken: Googling the last line above yields a couple results. A site in China has the text and while it has been taken down, the Google cache shows that there's a note in the Release Notes or ReadMe that comes with VFP to the effect, "The Help file omits documentation for Error 2115 (Execution of function or command is not allowed in context of SQL command). This error can occur if you have a UDF which attempts to close a table involved in SQL statement containing the UDF." M suspicion is that one of your macro-expanded fields got misinterpreted as a UDF. You may want to debug by dumping those values to a log file. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
