lookup(all) exportcell

[Mark Terry]

On Mar 7, 2008, at 1:08 PM, David Thompson wrote:

>> 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(), "")

Thanks, Dave. I tried that, and it certainly works, but was pretty  
slow (15,000 records). I was hoping for something like speedcopy,  
where a single lookup points to the record, but then be able catch the  
output in a var, instead of having it prybarred into the db. (That  
would probably make speedcopy a lot more useful, too.  ;)

M