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