Delete command...

Nancy Palmquist nlp at vss3.com
Wed Jul 7 07:26:04 PDT 2004


Chad McWilliams wrote:
> 
> Thanks for the info, Nancy.  I did understand about how the delete
> works, as far as how it waits until an end.  But no matter what I did,
> if I issued a delete within the @wlf processing, it would not delete the
> record, even after an end or an escape.  The record always remained.
> The only way I got it to work was by setting a flag and then, after an
> escape, delete the record if the flag was set.  I was just wondering if
> I was missing something, or this was the normal way to handle this type
> of situation.  I couldn't find anything in the docs that talked about
> this.
> 
> Thanks for all the responses, and suggestions!
> 
> -Chad McWilliams
> 
> -----Original Message-----
> From: Nancy Palmquist [mailto:nlp at vss3.com]
> Sent: Tuesday, July 06, 2004 3:50 PM
> To: Chad McWilliams
> Cc: filepro-list at seaslug.org
> Subject: Re: Delete command...
> 
> Chad McWilliams wrote:
> >
> > Sorry for the dumb question, but are you able to use the delete
> > command in @wlf processing?  When I try the following:
> >
> > @wlfm   If:   m eq "d"
> >         Then: delete; end
> >
> > the record remains, even though the line executes.
> >
> > If I instead do an escape and then issue the delete in the processing
> > that gets called with the escape, the delete works correctly.
> >
> > Am I missing something?
> >
> > -Chad McWilliams
> 
> I just finished reading the responses so far and I think they fell short
> of making it clear what is happening.
> 
> DELETE is a peculiar as far as commands go.  It is not executed at the
> time it is issued.  It is held in reserve and when you finally do an END
> or ESCAPE or whatever makes the end of the record processing happen and
> you are about to go to the next record, then the DELETE is done.
> 
> So you could put DELETE on line 1, continue to process for 400 lines and
> when it got to the END of your logic, then the record is DELETED, not
> before.
> 
> Does that help?
> 
> Nancy
> 
> --
> Nancy Palmquist
> Virtual Software Systems
> PHONE: (412) 835-9417                   Web site:  http://www.vss3.com
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list

Chad,

I will try using a DELETE in an @wlf and see what happens.  I usually
would not do that.  My DELETE routines are in CALL routines or GOSUBs
and I can not think of one time I would have put it in an @wlf.

If it does not work, I will report it to fpSupport.

Nancy
-- 
Nancy Palmquist 
Virtual Software Systems
PHONE: (412) 835-9417			Web site:  http://www.vss3.com



More information about the Filepro-list mailing list