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