empty records?
Bruce Easton
bruce at stn.com
Mon Jul 9 10:56:38 PDT 2018
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
More information about the Filepro-list
mailing list