runaway file when add records

Dennis Malen dmalen at malen.com
Mon Nov 30 21:42:01 PST 2009


Sorry to waste everyone's time on such a stupid question.

I was in the wrong screen that had all protected fields.

Maybe I can use the excuse that it is late and I was groggy. No--- that 
won't do. I was just careless.

Thanks to both Ken's, Scott and anyone else I missed. You all should go to 
sleep.

Thanks!

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Kenneth Brody" <kenbrody at spamcop.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Monday, November 30, 2009 11:53 PM
Subject: Re: runaway file when add records


> Dennis Malen wrote:
>> Created a filepro file. When I go into "add records" it starts to add 
>> records automatically. I have to control C out of the file.
>>
>> This happened many years ago and I don't remember how to fix this.
>>
>> There is no processing except for automatic processing  where I added:
>>
>> If: @rn gt "30"
>> Then: exit
>>
>> This gives me some protection.
>
> If there was no processing, then the problem was caused by going into add 
> records on a screen with no unprotected fields.  To avoid that in the 
> future, "don't do that".
>
>> Any thoughts other than having to recreate the entire file from scratch?
>
> I assume what you are asking is "how do I get rid of all of those new 
> records"?
>
> One way would be to first back up the file, "just in case".  Then, create 
> a processing-only output format consisting of a lone "DELETE" statement. 
> Finally, select only those new records.
>
> Were these records the only ones added today?  Then select on @CD equal to 
> today.
>
> Otherwise, find some other selection criteria that would only select these 
> new records.  (Perhaps @RN greater than the last "real" record, and then 
> manually find any stragglers that were added to previously-deleted 
> records.)
>
> Or, rereading your post, it sounds like this was a newly-created file.  If 
> that's the case, simply use the filePro directory program to delete the 
> records.
>
> -- 
> Kenneth Brody 



More information about the Filepro-list mailing list