empty records?

Fairlight fairlite at fairlite.com
Tue Jul 10 08:07:59 PDT 2018


You don't need write to create the empty record Ä only to save contents to
the record.

m->

On Tue, Jul 10, 2018 at 09:38:10AM -0500, Richard D. Williams via Filepro-list thus spoke:
> Just a note, the "end" within a @wef @wlf @wuk @wbl does not cause a write.
> 
> Richard D. Williams
> 
> On 7/9/2018 1:38 PM, Jose Lerebours via Filepro-list wrote:
> >Just to make sure, at no point throughout the process the "END"
> >command is reached!?!
> >
> >You have checked your @wef / @wlf and "END" is NOT used ...
> >instead, you are using "screen" command to control cursor flow ...
> >
> >
> >
> >On 07/09/2018 02:29 PM, Robert Haussmann via Filepro-list wrote:
> >>Thanks--have actually tried both "exit" itself (no "end"), and
> >>"save;exit", but records gets created in both cases in the newer
> >>fP versions.
> >>
> >>Bob
> >>
> >>>-----Original Message-----
> >>>From: Filepro-list [mailto:filepro-list-
> >>>bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf Of
> >>>Jose Lerebours via Filepro-list
> >>>Sent: Monday, July 09, 2018 2:26 PM
> >>>To: filepro-list at lists.celestial.com
> >>>Subject: Re: empty records?
> >>>
> >>>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
> >>>>>>>>>bounces+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
> >>>>>>>>>>>bounces+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
> >>_______________________________________________
> >>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 AVG.
> >https://www.avg.com
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Audio panton, cogito singularis.


More information about the Filepro-list mailing list