empty records?

Robert Haussmann haussma at nextdimension.net
Fri Jul 6 16:32:46 PDT 2018 

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

More information about the Filepro-list mailing list