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