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 The macro-expanded variables are all populated from the contents of object properties before the command is executed. The expressions are all valid; nothing has changed in the program. (Yeah, I know "NOT DELETED()" probably isn't doing me any good, and I should probably use text concatenation rather than macro expansion, but this has been working for 3 years, so I don't think those issues are causing this error.) In the past couple of days some errors and slowdowns suggesting connectivity issues have started cropping up. I thought I'd solved them by rerouting some network cables amongst my switches. It seemed to work for a while (about 3 months) but now they're happening again... In any case, Error 2115 is not documented. Does anybody have any information on what actually causes this error? Thanks! Ken Dibble www.stic-cil.org _______________________________________________ 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.
