>>Hi everyone,
>>
>>Just curios, is it possible to add thermometer during Append From (txtFile) type delimited? I just appended 5mln. records text file and it was not user friendly to see just wait window (fortunately, nobody except me has seen this :))
>>
>>Thanks in advance.
>
>Nadya,
>Trying to slow down one of the fastest commands ? I would really delete tag all before starting and recreate indexes afterwards. I agree with set talk and statusbar suggestions. You sure can't do that with import wizard because it's not distributable (surprised?:) For that reason I rolled my own wizard and used progress bar and guess for what I part I didn't use that prog bar at all, append from. If still you would do that be carefull with fgets(). It's unlikely it would hit you there but still has bugs in VFP6 (size). I don't suggest you to do but if still would do you could just add a temporary index that calls a UDF. UDF might update your thermometer. Or add an expression to append from that would call a UDF.
>IMHO status bar is enough.
>Cetin

Cetin,

Thanks a lot for your opinion. Actually, it was sort of excercise for me. Yesterday I appended from 5mln. text file. I forgot to delete tag all before appending, so the process tooke ~25 min. (not too bad, I believe). I had more time for UT :). Anyway, I was thinking about something fancy. The solution, I proposed, is not too bad, but I'm not sure, I will use it :)

Anyway, thinking about thermometres and progress bars I realized, that our thermometr class could be improved. I belive we use a modification of vfp classes (don't remember exactly which library). I believe, it would be great to add a StopProcess method to this class. I'll suggest this idea to our team workers.

Cetin, thanks again.