Josh,
At this point you need to start looking at specific values. What was the value in A, then after sending to B and finally after returning to A.
Also, was the problem when the data went from B to the memvar (Scatter) or when it went from the memvar to A (Gather)?
Barbara
>Sorry to keep doing this, but again, I believe what I will describe next, invalidates that theory. I had a large table (A), I said copy struct to B. Now B has the exact same structure as A. I then went somewhere in the middle of table A and said copy rest to B. I then said delete rest and deleted all records from A that where now in B. My program looked through B and put all records that wheren't in A into A (which happens to be all records in this case). Somewhere during scattering memvar from B and trying to gather into A, the "numeric overflow error. Data Lost" error happens. It's strange, because the the record that I'm trying to gather was in A at one point in time! A two digit integer is the one that refuses to go into table A, by the way. Not sure what the story is right now, but it seems that the solution of append to a temp table and then appending from it, will be a performance hit.
>
>
>-Josh