empty records?

Fairlight fairlite at fairlite.com
Mon Jul 9 11:18:52 PDT 2018


What happens when you simply put "delete" before your end/exit?  

m->

On Mon, Jul 09, 2018 at 06:11:35PM +0000, Robert Haussmann via Filepro-list thus spoke:
> Thanks Bruce--I appreciate the information!  fP tech confirmed this morning that they were able to repro the issue, so I'm confident we should get more information soon.  Unfortunately the code isn't something I can easily share (the table is pretty big because it does a number of different things; I don't have the time to "pare it down" to just  the relevant information.  Of note, though--I was not using "lookup -", however I was looking up to the same file with an alias.  I am curious to know if this is related.
> 
> Excellent point about @menu--I was starting to wonder why we wrote things the way we did, and that might be it.  (though honestly the original code was written in the 90's I believe, so it is entirely possible there is a better way to do this now).
> 
> As far as I know, the issue I am reporting would not occur in 5.6.X; it was introduced somewhere after 5.8.00.00 and before 5.8.00.08.
> 
> Thanks,
> 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: 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
> > >>>>> 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
> > 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

-- 
Audio panton, cogito singularis.


More information about the Filepro-list mailing list