I have fields called "name" in SQL Select statements that work fine, so I don't think it's that, but I wonder when that's going to bite me.
----- Original Message ----- From: Kurt Wendt <[email protected]> To: ProFox Email List <[email protected]> Cc: Sent: Wednesday, May 16, 2012 12:30 PM Subject: RE: select question That's exactly what I was thinking when I read the 1st post. -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of M Jarvis Sent: Wednesday, May 16, 2012 12:15 PM On Wed, May 16, 2012 at 8:38 AM, James Harvey <[email protected]> wrote: > This select generates an error message "Command contains unrecognized > phrase/keyword". > > SELECT hip_no, amount, name top 5 FROM stnhorse WHERE amount <> 0 AND > SUBSTR(hip_no,1,1) <> "R" ORDER BY hip_no desc > Is 'name' a keyword? -- Matt Jarvis _______________________________________________ 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/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** 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. _______________________________________________ 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.
