empty records?

Fairlight fairlite at fairlite.com
Tue Jul 10 14:48:43 PDT 2018


The very act of sitting on a new blank record creates that record and
leaves it there, though.  I forget the exact flags for this, but none of it
had to do with END, EXIT, or anything of the sort.  In this case, you just
needed to make sure the last thing you did was a DELETE.

That's how I was used to the blanks getting created.

m->

On Tue, Jul 10, 2018 at 05:39:18PM -0400, Jose Lerebours via Filepro-list thus spoke:
> What if:
> 
> 1. ESC ESC
> 
> 2. screen "aa"; end
> 
> 3. @wlfxx:if:then: end;
> 
> 
> I think it has to do with how it gets there!
> 
> 
> 
> 
> On 07/10/2018 10:38 AM, Richard D. Williams via Filepro-list wrote:
> >Just a note, the "end" within a @wef @wlf @wuk @wbl does not cause
> >a write.
> >
> >Richard D. Williams
> >
> >On 7/9/2018 1:38 PM, Jose Lerebours via Filepro-list wrote:
> >>Just to make sure, at no point throughout the process the "END"
> >>command is reached!?!
> >>
> >>You have checked your @wef / @wlf and "END" is NOT used ...
> >>instead, you are using "screen" command to control cursor flow
> >>...
> >>
> >>
> >>
> >>On 07/09/2018 02:29 PM, Robert Haussmann via Filepro-list wrote:
> >>>Thanks--have actually tried both "exit" itself (no "end"), and
> >>>"save;exit", but records gets created in both cases in the
> >>>newer fP versions.
> >>>
> >>>Bob
> >>>
> >>>>-----Original Message-----
> >>>>From: Filepro-list [mailto:filepro-list-
> >>>>bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf Of
> >>>>Jose Lerebours via Filepro-list
> >>>>Sent: Monday, July 09, 2018 2:26 PM
> >>>>To: filepro-list at lists.celestial.com
> >>>>Subject: Re: empty records?
> >>>>
> >>>>It makes no difference if you populate a bunch of dummy
> >>>>fields or real fields,
> >>>>"ESC ESC" and "END" will save the record ...
> >>>>
> >>>>In lieu of "END", use "screen" command to place cursor ...
> >>>>the key here is to
> >>>>never reach the "END" command if you do not wish to save blank records
> >>>>(multiple per session very possibly).
> >>>>
> >>>>I figure you have an "X" to exit off the browse lookup or
> >>>>checking for BRKY to
> >>>>see if user presses DEL DEL to break out ... in this case,
> >>>>simply do "DELETE;
> >>>>EXIT" and see what happens.
> >>>>
> >>>>
> >>>>
> >>>>On 07/09/2018 01:56 PM, Bruce Easton via Filepro-list wrote:
> >>>>>I needed to work on something related to this today, so I wanted to
> >>>>>share my findings. Keep in my  - this is on Windows filepro version
> >>>>>5.6.06.  Originally I was trying to just run from @menu to browse
> >>>>>another file and then popup update to collect data using a popup
> >>>>>screen on the current file that only has dummy fields on it.  I had
> >>>>>forgotten that you can't do this (filepro still thinks you're
> >>>>>attempting to update something on the current record even though in
> >>>>>this case it is just dummy fields that I want to ultimately write
> >>>>>somewhere else - not to the current record).
> >>>>>
> >>>>>Ergo the need to use the add-record mode technique to stand on a new
> >>>>>record.  So I changed the code to use @wef while standing on the new
> >>>>>record (-xa flag from the script line), and it works OK, but what I
> >>>>>noticed was this:  If I bail out before doing a popup or if I do the
> >>>>>popup but cancel out of the popup (where processing leads
> >>>>>to an "exit"
> >>>>>command), the new record being used to stand on for this purpose is
> >>>>>not saved, but if I save the popup (of dummy fields), and then bail
> >>>>>out of the program with cancel, the new record is saved. This
> >>>>>actually seems consistent from the point of view that filepro thinks
> >>>>>that any popup update (of the type "-" for the current file)  is an
> >>>>>attempt to update the current record whether it has only dummy fields
> >>>>>or real fields on it.
> >>>>>
> >>>>>I'm not sure if this behavior is consistent with previous versions,
> >>>>>but I know I'd want to see all of Bob's code to know if there was
> >>>>>something different  - at least between versions 5.6 and 5.8.
> >>>>>
> >>>>>
> >>>>>
> >>>>>On 7/6/18 10:01 PM, Jose Lerebours via Filepro-list wrote:
> >>>>>>I am blown away to hear this ... I've used this
> >>>>>>technique for as long
> >>>>>>as I can remember and the norm, as I understand it is/was, "exit"
> >>>>>>prior to "end" does not save the record.
> >>>>>>
> >>>>>>This has proven very handy for many quick processing where as
> >>>>>>
> >>>>>>*aa in a screen and
> >>>>>>
> >>>>>>@wef* in a processing table (I normally use a unique
> >>>>>>processing table
> >>>>>>for each need/task so -z and -y are always invoked)
> >>>>>>
> >>>>>>and parameter -xa to place in add record mode, which of course,
> >>>>>>triggers @wef* ...
> >>>>>>
> >>>>>>
> >>>>>>This is likely a BUG on this version - I just cannot imagine fp
> >>>>>>changing this out of the blues without notice.   So, how much do you
> >>>>>>get for finding a BUG?  A free upgrade or must you pay for the
> >>>>>>version that addresses this BUG as well?  ;-)  lol   I say, even if
> >>>>>>you are not "subscribed" for free upgrades, you are
> >>>>>>entitle to a FREE
> >>>>>>ONE!
> >>>>>>
> >>>>>>Nice find / great work ... Thanks!!!
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>On 07/06/2018 08:02 PM, Robert Haussmann via Filepro-list wrote:
> >>>>>>>Yep, this is indeed what is happening. It goes to a different
> >>>>>>>section where it writes out a text file and then exists.  But the
> >>>>>>>conclusion is the same--whereas previous versions of fP didn't save
> >>>>>>>the blank record on "exit", 5.8.00.15 does.
> >>>>>>>
> >>>>>>>Bob
> >>>>>>>
> >>>>>>>>-----Original Message-----
> >>>>>>>>From: Filepro-list [mailto:filepro-list-
> >>>>>>>>bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf
> >>>>Of
> >>>>>>>>Bruce Easton via Filepro-list
> >>>>>>>>Sent: Friday, July 06, 2018 7:38 PM
> >>>>>>>>To: filepro-list at lists.celestial.com
> >>>>>>>>Subject: Re: empty records?
> >>>>>>>>
> >>>>>>>>Perhaps the execution is never getting back up to the start label
> >>>>>>>>for some reason.  I would recommend setting up a session in debug
> >>>>>>>>to see where it goes when the user saves their input.
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>On 7/6/18 7:32 PM, Robert Haussmann via Filepro-list wrote:
> >>>>>>>>>Actually records aren't added through this method (I add the
> >>>>>>>>>records via a
> >>>>>>>>standard rclerk instance with a different screen number).
> >>>>>>>>>Yes, you are absolutely right-- it would be better not to have to
> >>>>>>>>>sit on any
> >>>>>>>>record.  I haven't considered using @menu--I'll have to give that
> >>>>>>>>some thought.
> >>>>>>>>>Just tried the pushkey suggestion (both single and
> >>>>>>>>>double), but no
> >>>>>>>>>joy...
> >>>>>>>>>
> >>>>>>>>>Bob
> >>>>>>>>>
> >>>>>>>>>>-----Original Message-----
> >>>>>>>>>>From: Filepro-list [mailto:filepro-list-
> >>>>>>>>>>bounces+haussma=nextdimension.net at lists.celestial.com] On
> >>>>Behalf
> >>>>>>>>>>bounces+Of
> >>>>>>>>>>Bruce Easton via Filepro-list
> >>>>>>>>>>Sent: Friday, July 06, 2018 7:23 PM
> >>>>>>>>>>To: filepro-list at lists.celestial.com
> >>>>>>>>>>Subject: Re: empty records?
> >>>>>>>>>>
> >>>>>>>>>>The technique used there begs more questions. (I would wonder,
> >>>>>>>>>>for instance, what happens to the record after it's been added -
> >>>>>>>>>>what is it used for and what it's supposed to retain..   Is it
> >>>>>>>>>>possible that it would be better designed to not sit on any
> >>>>>>>>>>record, say from @menu, while it's verifying that it has
> >>>>>>>>>>acceptable input...)
> >>>>>>>>>>
> >>>>>>>>>>But I see your point.  It's odd that it behaves differently now.
> >>>>>>>>>>You could try this instead for the first line:
> >>>>>>>>>>
> >>>>>>>>>>start  If: 1 eq ""
> >>>>>>>>>>        Then: pushkey "[BRKY][BRKY]"; end   '(or just one BRKY
> >>>>>>>>>>for
> >>>>>>>>>>Windows I
> >>>>>>>>>>think)
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>On 7/6/18 6:59 PM, Robert Haussmann via Filepro-list wrote:
> >>>>>>>>>>>Yes, I use "start" as the label. This code as actually written
> >>>>>>>>>>>like
> >>>>>>>>>>>2 decades(!)
> >>>>>>>>>>ago, so I'm having a little difficulty
> >>>>>>>>>>remembering.  But it looks
> >>>>>>>>>>like the general flow is:
> >>>>>>>>>>>@wef1 label ensures we are on the right screen #, if so go to
> >>>>>>>>>>>the "login"
> >>>>>>>>>>label, if not end:
> >>>>>>>>>>>12  -------   -   -   - -
> >>>>>>>>>>>@wef1  ? If: @sn eq "9"
> >>>>>>>>>>>           Then: goto login
> >>>>>>>>>>>     13  -------   -   -   -   -
> >>>>>>>>>>>           ? If:
> >>>>>>>>>>>           Then: end
> >>>>>>>>>>>     14  -------   -   -   -   -
> >>>>>>>>>>>
> >>>>>>>>>>>"login" is where we input username/password and check that they
> >>>>>>>>>>>are
> >>>>>>>>>>valid.
> >>>>>>>>>>>The actual processing itself (after some comments and variable
> >>>>>>>>>>declarations) is here (the "Start" label):
> >>>>>>>>>>>start  ? If: 1 eq ""
> >>>>>>>>>>>           Then:  exit 'do not save blank
> >>>>>>>>>>>records
> >>>>>>>>>>>     11  -------   -   -   -   -   -   -   - -   - -   -   -
> >>>>>>>>>>>-   -   -   -
> >>>>>>>>>>>
> >>>>>>>>>>>>-----Original Message-----
> >>>>>>>>>>>>From: Filepro-list [mailto:filepro-list-
> >>>>>>>>>>>>bounces+haussma=nextdimension.net at lists.celestial.com] On
> >>>>>>>>>>>>bounces+Behalf
> >>>>>>>>Of
> >>>>>>>>>>>>Bruce Easton via Filepro-list
> >>>>>>>>>>>>Sent: Friday, July 06, 2018 6:55 PM
> >>>>>>>>>>>>To: filepro-list at lists.celestial.com
> >>>>>>>>>>>>Subject: Re: empty records?
> >>>>>>>>>>>>
> >>>>>>>>>>>>Just curious - is there a label on that first line? (More
> >>>>>>>>>>>>importantly a filepro reserved word event trigger?) I'm just
> >>>>>>>>>>>>wondering how the program is supposed to test that first line
> >>>>>>>>>>>>prior to an "SAVE" or "CANCEL" coming
> >>>>>>>>>>from
> >>>>>>>>>>>>the user or the program...
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>>>>On 7/6/18 6:46 PM, Robert Haussmann via Filepro-list wrote:
> >>>>>>>>>>>>>Bruce and Jose--thank you both for your suggestions.  I think
> >>>>>>>>>>>>>I found out
> >>>>>>>>>>>>what's going on.  The one database is used for security
> >>>>>>>>>>>>(contains a list of usernames, pw's and access rights).  We go
> >>>>>>>>>>>>into this with "rclerk security -
> >>>>>>>>>>s9 -
> >>>>>>>>>>>>xa -d", and then the processing inputs username+password.  The
> >>>>>>>>>>>>first line
> >>>>>>>>>>in
> >>>>>>>>>>>>input processing is:
> >>>>>>>>>>>>>If: 1 eq ""
> >>>>>>>>>>>>>Then: exit
> >>>>>>>>>>>>>
> >>>>>>>>>>>>>Well, it seems that in 5.8.00.08, things
> >>>>>>>>>>>>>work as expected. But
> >>>>>>>>>>>>>in
> >>>>>>>>>>5.8.00.15,
> >>>>>>>>>>>>this results in a new record being saved. (not sure when this
> >>>>>>>>>>>>behavior was introduced, as I don't have the interim versions
> >>>>>>>>>>>>available
> >>>>>>>>to test.).
> >>>>>>>>>>>>>Bob
> >>>>>>>>>>>>>
> >>>>>>>>>>>>>>-----Original Message-----
> >>>>>>>>>>>>>>From: Filepro-list [mailto:filepro-list-
> >>>>>>>>>>>>>>bounces+haussma=nextdimension.net at lists.celestial.com] On
> >>>>>>>>Behalf
> >>>>>>>>>>Of
> >>>>>>>>>>>>>>Robert Haussmann via Filepro-list
> >>>>>>>>>>>>>>Sent: Friday, July 06, 2018 6:32 PM
> >>>>>>>>>>>>>>To: Bruce Easton <bruce at stn.com>; 'Filepro List'
> >>>>>>>>>>>>>><filepro-list at celestial.com>
> >>>>>>>>>>>>>>Subject: RE: empty records?
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>>Thanks--I've definitely run into this
> >>>>>>>>>>>>>>before (where basically
> >>>>>>>>>>>>>>it keeps adding records until you kill the process). That's
> >>>>>>>>>>>>>>not the case here--these are getting added one at a time it
> >>>>>>>>>>>>>>seems (in a day I might see anywhere between 20 and
> >>>>>>>>>>>>>>200 new records).  It is the strangest thing.  I have to
> >>>>>>>>>>>>>>believe it is related to the updated version....
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>>Bob
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>-----Original Message-----
> >>>>>>>>>>>>>>>>From: Filepro-list [mailto:filepro-list-
> >>>>>>>>>>>>>>>>bounces+haussma=nextdimension.net at lists.celestial.com]
> >>>>On
> >>>>>>>>>>Behalf
> >>>>>>>>>>>>Of
> >>>>>>>>>>>>>>>>Bruce Easton via Filepro-list
> >>>>>>>>>>>>>>>>Sent: Friday, July 06, 2018 6:23 PM
> >>>>>>>>>>>>>>>>To: filepro-list at lists.celestial.com
> >>>>>>>>>>>>>>>>Subject: Re: empty records?
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>The only thing I've seen that can cause this if you have
> >>>>>>>>>>>>>>>>screens that have no field on them
> >>>>>>>>>>>>>>>>that can be updated, and
> >>>>>>>>>>>>>>>>they you allow access to users to get to any of those
> >>>>>>>>>>>>>>>>screens with
> >>>>>>>>'Add Records'
> >>>>>>>>>>mode.
> >>>>>>>>>>>>>>>>Bruce
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>On 7/6/18 6:17 PM, Robert Haussmann
> >>>>>>>>>>>>>>>>via Filepro-list wrote:
> >>>>>>>>>>>>>>>>>Has anyone encountered an issue with fP in which
> >>>>>>>>>>>>>>>>>completely
> >>>>>>>>>>empty
> >>>>>>>>>>>>>>>>records are created seemingly at random?  We are seeing
> >>>>>>>>>>>>>>>>what appears to be phantom blank records getting inserted
> >>>>>>>>>>>>>>>>into specific filepro
> >>>>>>>>>>>>>>>databases.
> >>>>>>>>>>>>>>>>These dbs have run for years with no problem-the only
> >>>>>>>>>>>>>>>>change recently was updating from 5.8.00.03 to 5.8.00.15
> >>>>>>>>>>>>>>>>(Windows
> >>>>>>>>version).
> >>>>>>>>>>>>>>>>I'm honestly not even sure where to start looking-as I
> >>>>>>>>>>>>>>>>noted these apps ran for years (decades, really) without
> >>>>issue.
> >>>>>>>>>>>>>>>>>Thanks,
> >>>>>>>>>>>>>>>>>Bob Haussmann
> >>>>>>>>>>>>>>>>>-------------- next part
> >>>>>>>>>>>>>>>>>-------------- An HTML attachment
> >>>>>>>>>>>>>>>>>was scrubbed...
> >>>>>>>>>>>>>>>>>URL:
> >>>>>>>>>>>>>>>>><http://mailman.celestial.com/pipermail/filepro-
> >>>>>>>>>>list/attachments/2
> >>>>>>>>>>>>>>>>>01
> >>>>>>>>>>>>>>>>>80
> >>>>>>>>>>>>>>>>>706/dda5e6f2/attachment.html>
> >>>>>>>>>>>>>>>>>
> >>>>_______________________________________________
> >>>>>>>>>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>---
> >>>>>>>>>>>>>>>>This email has been checked for viruses by Avast antivirus
> >>>>>>>>software.
> >>>>>>>>>>>>>>>>https://www.avast.com/antivirus
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>_______________________________________________
> >>>>>>>>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>>>>>>_______________________________________________
> >>>>>>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>>>>>_______________________________________________
> >>>>>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>>>>>
> >>>>>>>>>>>>_______________________________________________
> >>>>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>>>_______________________________________________
> >>>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>>_______________________________________________
> >>>>>>>>>>Filepro-list mailing list
> >>>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>>_______________________________________________
> >>>>>>>>>Filepro-list mailing list
> >>>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>>
> >>>>>>>>_______________________________________________
> >>>>>>>>Filepro-list mailing list
> >>>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>>_______________________________________________
> >>>>>>>Filepro-list mailing list
> >>>>>>>Filepro-list at lists.celestial.com
> >>>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>>_______________________________________________
> >>>>>>Filepro-list mailing list
> >>>>>>Filepro-list at lists.celestial.com
> >>>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>>
> >>>>>
> >>>>>
> >>>>>---
> >>>>>This email has been checked for viruses by Avast antivirus software.
> >>>>>https://www.avast.com/antivirus
> >>>>>
> >>>>>_______________________________________________
> >>>>>Filepro-list mailing list
> >>>>>Filepro-list at lists.celestial.com
> >>>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>>_______________________________________________
> >>>>Filepro-list mailing list
> >>>>Filepro-list at lists.celestial.com
> >>>>Subscribe/Unsubscribe/Subscription Changes
> >>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>_______________________________________________
> >>>Filepro-list mailing list
> >>>Filepro-list at lists.celestial.com
> >>>Subscribe/Unsubscribe/Subscription Changes
> >>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>
> >>_______________________________________________
> >>Filepro-list mailing list
> >>Filepro-list at lists.celestial.com
> >>Subscribe/Unsubscribe/Subscription Changes
> >>http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>
> >>
> >>---
> >>This email has been checked for viruses by AVG.
> >>https://www.avg.com
> >
> >_______________________________________________
> >Filepro-list mailing list
> >Filepro-list at lists.celestial.com
> >Subscribe/Unsubscribe/Subscription Changes
> >http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Audio panton, cogito singularis.


More information about the Filepro-list mailing list