On 05/16/12 09:14, M Jarvis wrote: > 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? > No, the problem is that the syntax is invalid. From the VFP Help: SELECT [ALL][DISTINCT][TOP <exp>] <field list> ...... I.e., the "top 5" has to come before the field list.
Dan Covill _______________________________________________ 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.
