On Wed, May 27, 2009 at 10: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" > > The SQL SELECT command is > > SELECT * from &thetable INTO ARRAY &curname ; > WHERE NOT DELETED() AND &thewhere ; > ORDER BY &thekeyfield --------------------------------------------
Could you get a text output of what the real statement is instead of the source code above? That might get a better pointer to the trouble. My guess is one of the substutions is not coming across as you expect. -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ 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.
