Updating A Record

[John Esak]

Art,

I'll answer this private note on the list here... since I made a mistake in
what I told you before. Sorry.  I said do the test on the automatic table,
but I meant to say do the test @menu on the INPUT table.  This way, it
happens before you get to any records and will move you to the correct
record immediately.  You only have to protect against it happening more than
once. So do this with a global variable. that sets the first time and is
tested the second time you hit @menu... thereby not causing you to
repeatedly go to the desired record.  I'll elaborate more later... have to
run just now.

John






> -----Original Message-----
> From: Art Moore [mailto:cowboy at pcanswersinc.com]
> Sent: Monday, February 14, 2005 7:59 PM
> To: john at valar.com
> Subject: Re: Updating A Record
>
>
> John,
>
> Please see below....
>
> ----- Original Message -----
> From: "John Esak" <john at valar.com>
> To: "filePro mailing list" <filepro-list at seaslug.org>
> Sent: Thursday, February 10, 2005 7:24 PM
> Subject: RE: Updating A Record
>
>
> >
> >
> > > -----Original Message-----
> > > From: filepro-list-bounces at lists.celestial.com
> > > [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of
> Art Moore
> > > Sent: Thursday, April 08, 2004 10:11 AM
> > > To: filePro List
> > > Subject: Updating A Record
> > >
> > >
> > > Using Windows version 5.0.5
> > >
> > > >From a menu option I want to go directly to a particular
> > > character location
> > > in a particular field on a particular record in a particular file.
> > >
> > > Can I do that?  Any direction appreciated.
> > >
> > > THANKING EVERYBODY IN ADVANCE!!
> > >
> > > Art Moore
> > >
> > >
> > > _______________________________________________
> > > Filepro-list mailing list
> > > Filepro-list at lists.celestial.com
> > > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> > Art,
> >
> > Yes, you can do what you want.  Use the SCREEN command...
> > 4.5      SCREEN             Allows a cursor position to be specified.
> >
> >           Syntax
> >                SCREEN screen_name, fieldno, offset
> >
> >                where offset is the offset within the specified field t
> >                position the cursor.
> >
> >           Notes:
> >
> >                An offset of -1 will place the cursor after the last
> >                non-blank character, as if the user pressed F7.  If the
> >                offset is larger than the length of the field, the curs
> >                placed in the last character position of the field.
> >
> >
> > There are many ways to get directly to a particular record in
> rclerk... My
> > suggestion is use a parameter argument like -r 27  to take you to record
> 27.
> > Do this by testing for @pm ne "" in the automatic processing
> table and if
> it
> > is not null... lookup -  (dash) to that record...
> >
> >
> >       if: @pm ne ""
> >    then: lookup - r=@pm
> >
> > Then, once on that record... use the SCREEN command to put your cursor
> > wherever you want it.
> >
> > John Esak
> >
> >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> John,
>
> Thank you for responding to my request for help.  It was good to see your
> name and talk with you indirectly as it may be.
>
> If you have another minute I could use your help.  I'm not getting things
> goin quite right.
>
> What I am trying to do is get to the fpimport1 screen, field 1, 40th
> character in the fpimport file
>
> My menu line is:  /fp/rclerk  fpimport  -sfpimport1  -r 1 (I have
> alternated
> between having -xe and not having it with no real change in results)
>
> In the automatic table I have:
>
> If:  @pm ne ""
> Then: LOOKUP  -  r=@pm  -e
>
> If:
> Then: SCREEN "fpimport1",1,"40"
>
> The SCREEN command works as it does put the cursor in the right
> field and on
> the right character.  But, for it to work I have to remove the
> first If/Then
> line in the automatic table shown above1.  I also then have to press ENTER
> at the '1-record number' prompt and ENTER again at the 'Enter
> Record Number
> prompt' to get to record 1and then U for Update once on the record.
>
> If I leave the first line in I still press ENTER at the '1-record number'
> prompt.  But, then when I press ENTER at the 'Enter Record
> Number' prompt I
> am returned to the menu.
>
> I have tried numerous differnt combinations including using the SCREEN
> command in the input table.  No combination worked for me.
>
> Any help VERY MUCH APPRECIATED!!!
>
> Art
>
>
>
>
>
>