Name is actually a fieldname in the table. I know it's no excuse, but I created the table in 1985 BEFORE I knew about not using keywords as fieldnames, but after it was too late to change the fieldname. I've got other fields like that too, such as "date", in some of my older tables...
Anyway, I'll be retiring in a little over a year, so I doubt I'll get around to rectifying that major embarrassment. And, thanks for the advice to move the top 5, which worked of course, and now I know why it didn't before thanks to this list, and all the good people who are willing to help :) James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Wednesday, May 16, 2012 12:31 PM To: ProFox Email List 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 [excessive quoting removed by server] _______________________________________________ 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.
