Some Sort of Control From The Browse Screen
John Esak
john at valar.com
Sun Oct 17 16:06:19 PDT 2010
No, you showed 5="Y" or something like that on AUTOMATIC... That is a no-no.
It's writing a real field on the AUTOMATIC table. No, there isn't a WRITE
command, but you are still modifying the record in AUTO... And that's
baaaaaaad. Please let's not go into it again as to why.... Suffice to say,
it's bad because the record is not locked and if two people or more are
browsing with this kind of coding, you are going to get unreliable stuff in
the indexes, and well, it's just plain bad programming. But, I'm sure you
know that. Don't know why you suggest it a lot, but that's your thing. I
just mention the bad effects to play devil's advocate and explain to
unitiates that changing values of real fields on the AUTO table...
Especially of indexed fields is not a good idea. You and anyone else is
welcome to do it, however.
John
> -----Original Message-----
> From: flowersoft at compuserve.com [mailto:flowersoft at compuserve.com]
> Sent: Sunday, October 17, 2010 5:11 PM
> To: john at valar.com; filepro-list at lists.celestial.com
> Subject: RE: Some Sort of Control From The Browse Screen
>
> John, I took sh*t for using "write" in automatic processing
> which was, at
> that time, not only allowed but documented as a legal
> operation in the AWM.
> Not by updating real fields from automatic processing.
> In this case, however, what could possibly happen by doing this from
> automatic?
> No one can update the record from screen 9 because there are
> no fields there
> to update.
> If they use screen 1, then nothing takes place from automatic except
> whatever other normal processing is there.
> If someone has the record he's trying to clear in update mode
> while he's
> trying to clear it, he will get "Record is Being Updated -
> Access Denied"
> The only thing I can see happening is that when someone is
> updating the
> record they might hit <Ctrl> + C or <Del><Del> to get out of
> the record, and
> in that case they would be put into the browse screen. And
> this can be
> completely avoided by simply adding \fp\rclerk filename -s9
> -xi -b -y myauto
> to the menu line.
> Automatic processing is a very powerful tool, which I use
> extensively, and
> in this particular case is the only way I see to accomplish
> what he wants to
> do.
>
> PS - That program with the "write" from 25+ years ago, still
> running strong
> and no problems reported because of it. Just lucky, I guess. ;-)
>
>
> -----Original Message-----
> From:
> filepro-list-bounces+flowersoft=compuserve.com at lists.celestial.com
> [mailto:filepro-list-bounces+flowersoft=compuserve.com at lists.c
> elestial.com]
> On Behalf Of John Esak
> Sent: Sunday, October 17, 2010 12:03 PM
> To: filepro-list at lists.celestial.com
> Subject: RE: Some Sort of Control From The Browse Screen
>
> Well, George's methodology uses a "no-no" of writing real
> fields on the
> automatic table. He took an untold raft of sh*t on
> CompuServer about 25
> years ago for suggesting this. It really isn't a good idea,
> no offense to
> his trying to be helpful.
>
> As for your snip... I haven't checked, but how are you going
> to let them
> (U)pdate the record normally if you hijack the @keyU for this purpose.
> Normally, with @keyU you would hae to end with a RESTART to
> get them "onto"
> the screen. I haven't really looked at your code, but what I
> heard very
> quickly did not sound like it would work. There is still no
> differenetiation bvetween coming off the browse and coming
> out of @keyU.
> I'll look again, but didn't see it.
> John
>
>
> > -----Original Message-----
> > From: filepro-list-bounces+john=valar.com at lists.celestial.com
> > [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Scott Walker
> > Sent: Sunday, October 17, 2010 12:02 AM
> > To: flowersoft at compuserve.com; 'filePro Mailing List'
> > Subject: RE: Some Sort of Control From The Browse Screen
> >
> > Thanks for the methodology. I'll give it a try. Here's what
> > I thought
> > might work:
> >
> > Maybe I set up a variable Just_Came_From_Browse. Then when
> > the hit "B" for
> > browse I set Just_Came_From_Browse="Y". Then I get to the
> > actual browse
> > using pushkey. Then when I press "U" to update on the browse
> > format, I go
> > to the screen and on the first field I run WEF and look at
> > the value of
> > Just_Came_From_Browse. It it's "Y" then I do my special
> > stuff, and use
> > Pushkey to record the screen and return to the Browse format.
> > If it's "N",
> > I do nothing.
> >
> > Also, in case the user picks a record from the browse format
> > by pressing
> > <enter> instead of "U", then @ENTSEL I will set
> > Just_Came_From_Browse ="N".
> >
> > Will this work. What do the real fp brains think? Of
> > course, it limits me
> > to using on the "U" key to accomplish my task, and there is
> > no way for me to
> > change the prompt, so it ain't slick...but will it work?
> > Also, I must have
> > the user menu set so that the user does not go to the
> > Add/Inquire/Update
> > which would allow them to toggle the browse mode on & thus go
> > directly to
> > the browse format. I can only allow them to call up a record
> > first, then
> > hit "B" to browse for my method to know that they went to
> the browse.
> >
> > Regards,
> >
> > Scott
> >
> >
> >
> > -----Original Message-----
> > From: flowersoft at compuserve.com [mailto:flowersoft at compuserve.com]
> > Sent: Saturday, October 16, 2010 11:03 PM
> > To: 'Scott Walker'; 'filePro Mailing List'
> > Subject: RE: Some Sort of Control From The Browse Screen
> >
> > If all you want is the ability to toggle a field on or off,
> > like checking
> > off the items that have cleared in your checking account,
> > then I think the
> > solution is fairly simple if you don't mind using "U" as your
> > toggle key.
> > Let's say your main screen is 1 and the field you want to
> > toggle on/off is
> > field 5.
> >
> > Create a screen 9. Screen 9 should be a screen with no
> > fields on it, just a
> > blank screen.
> >
> > The menu line: \fp\rclerk filename -s9 -xi -b
> > "your_browse_format_should_show_field 5"
> >
> > Automatic processing:
> >
> > If: @sk="brky"
> > Then: switchto 1; goto JUMP1
> > If: @sn="9" and 5=""
> > Then: 5="Y"; end
> > If: @sn="9" and 5="Y"
> > Then: 5=""; end
> > JUMP1 If: ... 'other processing if any
> > Then: ...
> >
> >
> > Input processing:
> >
> > @entsel If: @sn="9"
> > Then: entsel=""; pushkey "b"; end
> > If: entsel="y"
> > Then: entsel=""; switchto 9; pushkey "b"; end
> > If:
> > Then: entsel="Y"
> > If:
> > Then: declare entsel(1,yesno,g)
> > If:
> > Then: ... 'other processing here if needed
> >
> > All you have to tell your users is to press "U" to toggle
> > field 5 from "" to
> > "Y" or from "Y" to ""
> > And if they need to look or update the record to hit <ctrl> +
> > c or <del>del>
> > As soon as they finish looking or updating the record, they
> > will be returned
> > to the browse screen
> > where they can keep pressing "U" to toggle field 5.
> >
> >
> > -----Original Message-----
> > From:
> > filepro-list-bounces+flowersoft=compuserve.com at lists.celestial.com
> > [mailto:filepro-list-bounces+flowersoft=compuserve.com at lists.c
> elestial.com]
> > On Behalf Of Scott Walker
> > Sent: Thursday, October 14, 2010 4:12 PM
> > To: 'filePro Mailing List'
> > Subject: Some Sort of Control From The Browse Screen
> >
> > Is there no way, no how, to get any programmable control of
> > what happens
> > when the user is on a browse (the full file type of
> > browse..not the lookup
> > browse).
> >
> >
> >
> > I want to be highlighting a record and press a key (lets say
> > "T") and have
> > it check off the highlighted record (as in checking off the
> > items in your
> > check book that have cleared). So programmatically when you
> > pressed "T" on
> > the browse screen, the highlighted record would have the
> value of it's
> > "Cleared" field set to "Y" and the browse would be refreshed so the
> > "Cleared" field would now show "Y".
> >
> >
> >
> > I'm pretty sure this can't be done but if anyone has a wild &
> > crazy way
> > they've made it happen, I'd love to know.
> >
> >
> >
> > I could even live with, when on the browse screen, press "U"
> > and go into
> > update on the screen. Maybe I could take over at that point,
> > change the
> > Cleared field to "Y" and then record the screen and go back
> > to the browse
> > screen. But how would I tell that I had been on the browse
> > and pressed
> > "U"?
> >
> >
> >
> >
> >
> > Regards,
> >
> >
> >
> > Scott
> >
> >
> >
> >
> >
> > Scott Walker
> >
> > RAM Systems Corp
> >
> > (704) 896-6549
> >
> > ScottWalker at RAMSystemsCorp.com
> >
> >
> >
> > www.RAMSystemsCorp.com
> >
> >
> >
> >
> >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> > http://mailman.celestial.com/pipermail/filepro-list/attachment
> s/20101014/cb6
> > bcc59/attachment.html
> > _______________________________________________
> > 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