runaway file when add records
Kenneth Brody
kenbrody at spamcop.net
Mon Nov 30 20:53:40 PST 2009
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