Hi Gaylen,
A couple of questions. Is it possible that user picks the wrong file the first time around? By any chance do you have an error handler in place that could hide error in the APPEND command?
As a workaround, you can create another cursor, do second append, compare record count and act accordingly.
>I have an append program with the following code:
>
>
>lcdirectory = Sys(5) + Sys(2003)
>SET DEFAULT TO "H:\commission download"
>lcFileName = Getfile("txt","Get USIS Download")
>
>SET DEFAULT TO (lcdirectory)
>Create Cursor usisxls (field1 N(9),field2 c(10))
>Select usisxls
>Append From (lcFileName)Delimited With Tab
>
>
>
>Ocassionally the number of records that are appended is only a portion of records that should have been appended. If I run it a second time the complete file is appended. The download usually consist of approx. 3,000 to 20,000 records, and size is not a factor as it fails on randonly for both file sizes.
>
>Any ideas as to what might be happening.
>Gaylen
--sb--