empty records?

Jose Lerebours fpgroups at gmail.com
Fri Jul 6 19:01:36 PDT 2018


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 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



More information about the Filepro-list mailing list