lookup(all) exportcell
David Thompson
dthmpsn1 at uiuc.edu
Fri Mar 7 10:08:59 PST 2008
>I'm trying to build an array of record values., without going to the
>record. If I use lookupall(, I get all text values, but I lose all but
>the first element of fields with CR's (as I would with exportcell). If
>I use lookup(, I need to manually convert all values to text.
>Exportline( is perfect, but it requires that the record in question be
>the current record... which can spoil selection. Is there a way to
>mimic exportline without requiring the record to be current?
An ArrayBuild treats each record in turn as
temporarily current, so you should be able to use
ArrayBuild MyArray, sep, "", ?(KeyField=KeyValue, exportline(), "")
Dave
More information about the Qna
mailing list