Tracy, Yes it does say that but must admit I used it before I noticed that and it always performed faultlessly. Either I was lucky or the doc may be incomplete.
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: 20 January 2015 14:55 To: [email protected] Subject: RE: using select in a case Dave Crozier wrote on 2015-01-20: > 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 > Dave, I don't think I've ever used the LOOKUP() function. Reading the help states it DOES move the record pointer. Even moves the related child tables records. Tracy Pearson PowerChurch Software [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.
