empty records?

Jose Lerebours fpgroups at gmail.com
Mon Jul 9 11:38:03 PDT 2018


Just to make sure, at no point throughout the process the "END" command 
is reached!?!

You have checked your @wef / @wlf and "END" is NOT used ... instead, you 
are using "screen" command to control cursor flow ...



On 07/09/2018 02:29 PM, Robert Haussmann via Filepro-list wrote:
> Thanks--have actually tried both "exit" itself (no "end"), and "save;exit", but records gets created in both cases in the newer fP versions.
>
> Bob
>
>> -----Original Message-----
>> From: Filepro-list [mailto:filepro-list-
>> bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf Of
>> Jose Lerebours via Filepro-list
>> Sent: Monday, July 09, 2018 2:26 PM
>> To: filepro-list at lists.celestial.com
>> Subject: Re: empty records?
>>
>> It makes no difference if you populate a bunch of dummy fields or real fields,
>> "ESC ESC" and "END" will save the record ...
>>
>> In lieu of "END", use "screen" command to place cursor ... the key here is to
>> never reach the "END" command if you do not wish to save blank records
>> (multiple per session very possibly).
>>
>> I figure you have an "X" to exit off the browse lookup or checking for BRKY to
>> see if user presses DEL DEL to break out ... in this case, simply do "DELETE;
>> EXIT" and see what happens.
>>
>>
>>
>> On 07/09/2018 01:56 PM, Bruce Easton via Filepro-list wrote:
>>> I needed to work on something related to this today, so I wanted to
>>> share my findings. Keep in my  - this is on Windows filepro version
>>> 5.6.06.  Originally I was trying to just run from @menu to browse
>>> another file and then popup update to collect data using a popup
>>> screen on the current file that only has dummy fields on it.  I had
>>> forgotten that you can't do this (filepro still thinks you're
>>> attempting to update something on the current record even though in
>>> this case it is just dummy fields that I want to ultimately write
>>> somewhere else - not to the current record).
>>>
>>> Ergo the need to use the add-record mode technique to stand on a new
>>> record.  So I changed the code to use @wef while standing on the new
>>> record (-xa flag from the script line), and it works OK, but what I
>>> noticed was this:  If I bail out before doing a popup or if I do the
>>> popup but cancel out of the popup (where processing leads to an "exit"
>>> command), the new record being used to stand on for this purpose is
>>> not saved, but if I save the popup (of dummy fields), and then bail
>>> out of the program with cancel, the new record is saved.  This
>>> actually seems consistent from the point of view that filepro thinks
>>> that any popup update (of the type "-" for the current file)  is an
>>> attempt to update the current record whether it has only dummy fields
>>> or real fields on it.
>>>
>>> I'm not sure if this behavior is consistent with previous versions,
>>> but I know I'd want to see all of Bob's code to know if there was
>>> something different  - at least between versions 5.6 and 5.8.
>>>
>>>
>>>
>>> On 7/6/18 10:01 PM, Jose Lerebours via Filepro-list wrote:
>>>> 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
>>>>>>>> bounces+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
>>>>>>>>>> bounces+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
>>>> _______________________________________________
>>>> 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



More information about the Filepro-list mailing list