empty records?
Robert Haussmann
haussma at nextdimension.net
Fri Jul 6 17:02:24 PDT 2018
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
More information about the Filepro-list
mailing list