empty records?

Bob Simcoe bob at midcityoffice.com
Mon Jul 9 11:25:52 PDT 2018


I've always used 
Then: delete ; close ; exit
In add records mode on the standing file.

Bob Simcoe


> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+bob=midcityoffice.com at lists.celestial.com] On Behalf Of Bruce
> Easton via Filepro-list
> Sent: Monday, July 09, 2018 1:57 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: empty records?
> 
> 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
> 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
> 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


More information about the Filepro-list mailing list