As long as you fully qualify the field name in a SQL select, you should have no problems. At least, I've never run into any that way.
SELECT TOP 5 XX.name, XX.desc FROM yourtable XX etc... Fred On Wed, May 16, 2012 at 10:23 AM, Frank Cazabon <[email protected]>wrote: > The only time I've ever been bitten is when I had a field called "desc" > which messed up some SQL. Since then I've always made sure my field and > variable names are not keywords. > > Frank. > > Frank Cazabon > > > > On 16/05/2012 12:49 PM, Michael Madigan wrote: > > 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? > [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/CAJCBksrEg5oB17_Tg_S8q4fj5ukA2PM=6m7wjjx6souxzk6...@mail.gmail.com ** 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.
