Never too old to learn but often too old to remember! Dave
-----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Allen Sent: 20 January 2015 14:35 To: [email protected] Subject: RE: using select in a case Yes Dave, a long list of Case in this instance. I do use icase elsewhere. I was more worried it moved to the table though I would probably select what I want anyway. Anyway it works a treat. Don't know why I have never used it before. Another VFP gem. Al -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 20 January 2015 15:12 To: [email protected] Subject: RE: using select in a case I agree with Jean, Lookup() doesn't move the record pointer. In fact I have used it in a sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
