Sleep!<br><br>It is only 4pm here in Australia!<br><br><div class="gmail_quote">On Tue, Dec 1, 2009 at 3:42 PM, Dennis Malen <span dir="ltr"><<a href="mailto:dmalen@malen.com">dmalen@malen.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Sorry to waste everyone's time on such a stupid question.<br>
<br>
I was in the wrong screen that had all protected fields.<br>
<br>
Maybe I can use the excuse that it is late and I was groggy. No--- that<br>
won't do. I was just careless.<br>
<br>
Thanks to both Ken's, Scott and anyone else I missed. You all should go to<br>
sleep.<br>
<br>
Thanks!<br>
<br>
Dennis Malen<br>
516.479.5912<br>
----- Original Message -----<br>
From: "Kenneth Brody" <<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>><br>
To: "Dennis Malen" <<a href="mailto:dmalen@malen.com">dmalen@malen.com</a>><br>
Cc: <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br>
Sent: Monday, November 30, 2009 11:53 PM<br>
Subject: Re: runaway file when add records<br>
<br>
<br>
> Dennis Malen wrote:<br>
>> Created a filepro file. When I go into "add records" it starts to add<br>
>> records automatically. I have to control C out of the file.<br>
>><br>
>> This happened many years ago and I don't remember how to fix this.<br>
>><br>
>> There is no processing except for automatic processing where I added:<br>
>><br>
>> If: @rn gt "30"<br>
>> Then: exit<br>
>><br>
>> This gives me some protection.<br>
><br>
> If there was no processing, then the problem was caused by going into add<br>
> records on a screen with no unprotected fields. To avoid that in the<br>
> future, "don't do that".<br>
><br>
>> Any thoughts other than having to recreate the entire file from scratch?<br>
><br>
> I assume what you are asking is "how do I get rid of all of those new<br>
> records"?<br>
><br>
> One way would be to first back up the file, "just in case". Then, create<br>
> a processing-only output format consisting of a lone "DELETE" statement.<br>
> Finally, select only those new records.<br>
><br>
> Were these records the only ones added today? Then select on @CD equal to<br>
> today.<br>
><br>
> Otherwise, find some other selection criteria that would only select these<br>
> new records. (Perhaps @RN greater than the last "real" record, and then<br>
> manually find any stragglers that were added to previously-deleted<br>
> records.)<br>
><br>
> Or, rereading your post, it sounds like this was a newly-created file. If<br>
> that's the case, simply use the filePro directory program to delete the<br>
> records.<br>
><br>
> --<br>
> Kenneth Brody<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div><br>