empty records?
Bruce Easton
bruce at stn.com
Fri Jul 6 16:38:15 PDT 2018
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
More information about the Filepro-list
mailing list