empty records?
Robert Haussmann
haussma at nextdimension.net
Fri Jul 6 15:46:43 PDT 2018
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
More information about the Filepro-list
mailing list