empty records?

Bruce Easton bruce at stn.com
Mon Jul 9 11:51:08 PDT 2018


In my case under 5.6.06, Jose, ESC ESC of the popup, then testing @sk eq 
"BRKY" to then just executing "exit" saved the new record being used to 
stand on.  (Absolutely no "end" statement in this flow, [explicit end or 
assumed end].)

But yes, performing the delete prior to exiting does delete the temp 
record, so that works for this technique at least under 5.6.06.

Bruce

On 7/9/18 2:26 PM, Jose Lerebours via Filepro-list wrote:
> 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 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
>>>
>>> _______________________________________________
>>> 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





More information about the Filepro-list mailing list