> > 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.
Well I suppose it could be an odd case of a string getting into the data that can also be interpreted as code. That happened once with the surname "McClintock" (McCl...INTO...ck). My query (de)construction parser was searching for "into" $ whatever and drawing the wrong conclusion. That particular one couldn't happen here but I guess something like it could get into the WHERE expression. My error logging system doesn't get that granular; all it does is report the error number, message, and ASTACKINFO() stuff. I could add a special logging function to that piece of code though--if this happens again. So far I've only seen it once. Thanks, Steve. Ken 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.
