Updating another file from within Sort/Select Processing

[Jeff Harrison]

--- Scott Walker <scottw1 at alltel.net> wrote:

> I don't remember if this is OK to do:
> 
> During sort/select processing, can you do a lookup
> to another file and
> delete a record from that other file without any
> problems.
> 
> Regards,
> 
> 
> Scott
> 

I have seen this from time to time.  So it can
certainly be done.  I would recommend that you avoid
doing this if possible though.  In my opinion you
should use sort/select processing for sorting and
selecting (for the most part). If you want to do
deleting, then create another process that runs
separately - this could be called something like
deletexxx where xxx is something descriptive.

This would make your processes more readable and
self-documenting.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The fastest and
easiest ways to generate filepro exports and imports.



 
____________________________________________________________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/