Hi Harsh

I see you are having a lot of trouble with your programming generally. You don't know how to handle errors. You don't know how to optimize. You don't respond when people give you advice.

I have experience with processing many many millions of records. There are others here that are very good programmers.

Make a sample of your tables. Make a sample of your text files. Show the code that is to process the files. You will get one or more versions of code back. You may get working examples of error handling, You certainly will get examples of ways to improve the speed.

It will not happen well if you show a little chunk of code and yell help.


>I have a SCAN-ENDSCAN loop with Millions of records in between. The records are infact the name of Files like C:\Bills\1.txt,c:\bills\2.txt.
>
>The code between takes the files and edit the TXT files as per my requirement.
>
>Generally Things go fine, however sometimes there are files with error inside TXT files only and my code does not satisfy the condition and therefore gives an error window like
>
>CANCEL,SUSPEND,IGNORE.
>
>At this time I Select IGNORE and my process goes further to the next record.
>
>Is there anyway by which is during course of SCAN ENDSCAN Error occurs, it should automatically IGNORE and move to the next record. so that I have not to wait infront of the screen for contionious monitorng
>
>If yes, kindly provide the piece of that Code.
>
>Regards