>Folks,
>I am running VFP6 and W2K, both with the latest service packs. After installing SP2 on W2K (but I am not sure that is the problem) I noticed that the following code was failing to behave correctly.
>
>
> DIMENSION ThisForm.F50record(77)
> COPY TO ARRAY ThisForm.F50record NEXT 1
> INSERT INTO HISTORY\hstf50 FROM ARRAY ThisForm.F50record
>
>
>Both the F50.dbf and HstF50.dbf are identical. This code has been in place and functioning properly for nearly three years. The symptom is that one field near the end of the row of the HstF50 table is missing data present in that row in the F50 table and, two fields down the row, part of data from the wrong field is in another field. (Note that this code used to be in an "WITH ...ENDWITH" construct, but I have added 'ThisForm' to see what happens.
I'd suspect the field immediately after the last good field. Is it a memo? One thing to check is to suspend immediately before the Insert line and see what's stored in the array, specially around that field. Sounds like the old scatter-gather glitch when it didn't count the memos.
If the array is populated properly, you may try to select the target table and Append From Array.