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