Roi ---

I've been poking around with things like SELECT * WHERE RECNO() < 0 to no avail.

Hmmm....COPY TO ARRAY respects the negative records....can you change your architecture to use an array and not a cursor? Or you could create a temp table and APPEND FROM ARRAY.


>As a matter of fact it is. I knew about the negative record numbers, but I thought the select would just grab whatever was in there.
>
>Is there anyway around it.
>
>I have a textbox on a form that has the select code in it's refresh method. It looks at the view and builds a string out of all the records for it's value. Only it doesn't work very well at moment :|
>
>>Hi Roi ---
>>
>>Mind you, this is just a theory, but is the view table buffered? If so, the appended records would have negative record numbers and that *might* be a part of the problem.
>>
>>