runaway file when add records

Ken Cole ken.m.cole at gmail.com
Mon Nov 30 21:56:07 PST 2009


Sleep!

It is only 4pm here in Australia!

On Tue, Dec 1, 2009 at 3:42 PM, Dennis Malen <dmalen at malen.com> wrote:

> 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
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20091201/e2286277/attachment.html 


More information about the Filepro-list mailing list