empty records?

Bruce Easton bruce at stn.com
Fri Jul 6 16:22:54 PDT 2018


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





More information about the Filepro-list mailing list