Updating one file from within another

Joe Chasan joe at magnatechonline.com
Thu Apr 29 13:08:00 PDT 2004


On Thu, Apr 29, 2004 at 03:45:41PM -0400, Vicky Prigg wrote:
> 
> I actually tried the -r flag with the @PM but my problem is this:  I
> have a quote number (unique #) that I'm passing to the other file.  How
> do I pass that on the line 
> 
> system "/appl/fp/dclerk vpickup -s0 -r ???"
> 
> All of the samples that I see show a value in quotations.  Since my
> value will change every time, I just want to put the field number or a
> dummy field.

lets say for example your quote # is field 23 - i'm assuming that because
you say number, there are no spaces, so its quite easy.  if it is the
last thing on the line, do:

system "/appl/fp/dclerk vpickup -s0 -r"<23

-joe

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of
> filepro-list-request at lists.celestial.com
> Sent: Thursday, April 29, 2004 2:26 PM
> To: filepro-list at lists.celestial.com
> Subject: Filepro-list Digest, Vol 3, Issue 70
> 
> Send Filepro-list mailing list submissions to
> 	filepro-list at lists.celestial.com
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://mailman.celestial.com/mailman/listinfo/filepro-list
> or, via email, send a message with subject or body 'help' to
> 	filepro-list-request at lists.celestial.com
> 
> You can reach the person managing the list at
> 	filepro-list-owner at lists.celestial.com
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Filepro-list digest..."
> 
> 
> Today's Topics:
> 
>    1. RE: Dreport & rreport (GCC Consulting)
>    2. Re: Why so slow (Bill Vermillion)
>    3. RE: Dreport & rreport (Jeff Harrison)
>    4. Re: Updating one file from within another (Joe Chasan)
>    5. Own Messages on List [was: Re: DECLARE EXTERN] (Bob Stockler)
>    6. Re: Own Messages on List [was: Re: DECLARE EXTERN]
>       (Jay R. Ashworth)
>    7. Re: Why so slow (Rick Hane)
>    8. RE: Own Messages on List [was: Re: DECLARE EXTERN] (Jeff Harrison)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 29 Apr 2004 13:55:04 -0400
> From: GCC Consulting <gcc at optonline.net>
> Subject: RE: Dreport & rreport
> To: 'Jeff Harrison' <Jeff.Harrison at Epixweb.com>,	'Filepro 2 List'
> 	<filepro-list at lists.celestial.com>
> Message-ID: <0HWY001QP1SU3G at mta7.srv.hcvlny.cv.net>
> Content-Type: text/plain; charset=us-ascii
> 
>  
> 
> -----Original Message-----
> From: Jeff Harrison [mailto:Jeff.Harrison at Epixweb.com] 
> Sent: Thursday, April 29, 2004 1:45 PM
> To: 'gcc at optonline.net'; Filepro 2 List
> Subject: RE: Dreport & rreport
> 
> Richard Kreiss wrote:
> > 
> > Having a problem with the following code:
> > 
> > Native 5.0.11
> > 
> >    9  Then: po=@pw;st=@pm;ct="15";
> >    10  Then: 'debug on
> >    11  Then: GOSUB pst_hed
> > loop     If: ct ne "0"
> >    12  Then: PRINT;ct = ct -"1"
> >          If: ct = "0"
> >    13  Then: END
> >    14  Then: GOTO loop
> > pst_hed  If: 
> 
> [snip]
> 
> Are you aware that pst_hed only happens once?  You initialize your ct
> counter to
> "15", but line 13 ensures that your loop will never occur.  Also, you
> only
> assign po one time, so perhaps you only want this to happen once.
> 
> If the post does not happen with rclerk I would add some msgbox
> statements for
> debugging purposes. 
>  
> ------------------------------------------------------------------------
> -------
> Pst_hed only need to run once.  This routine prints 15 address labels
> from the
> same record.
> Line 13 tests the counter and ends the program when it gets to "0".
> Otherwise
> line 14 executes
> And the loop is repeated.
> 
> My problem is on the first time this system called program runs, the
> lookup
> fails as the record is not found.
> If the same selection from the browse lookup is made again, the record
> is found
> and the values posted.  Al succeeding records selected will post
> correctly.  
> 
> If I run a report, printing the orders listed in the browse, first,
> everything
> works fine. 
> 
> The above only happens in rreport; dreport runs correctly each time.
> 
> Richard Kreiss
> GCC Consulting 
>  
> 
> 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 29 Apr 2004 13:59:04 -0400
> From: Bill Vermillion <fp at wjv.com>
> Subject: Re: Why so slow
> To: filePro Mailing List <filepro-list at seaslug.org>
> Message-ID: <20040429175904.GA40005 at wjv.com>
> Content-Type: text/plain; charset=us-ascii
> 
> On Thu, Apr 29, 2004 at 01:36:46PM -0400, GCC Consulting thus spoke:
> > Rick,
> 
> > How is he connecting? The programs may be running fast enough
> > but the screen refreshes may be very slow.
> 
> > A better solution would be for him to use pcAnywhere or a service like
> > "GoToMyPc" to access a pc and not the server from home.  
> 
> > I hate having anyone accessing the server. Also, if you upgrade
> > in the future, Terminal Service client licenses are not
> > included with Win XP and will have to be purchased separately.
> > The client license has been included with NT and Win2K.
> 
> And if you don't tell anyone you could use VNC.   If you read the
> license carefully you can't use any remote access products on
> current MS products without violating license.  You use terminal
> server or be in violation - and that includes PcAnywhere.
> 
> > -----Original Message-----
> > From: filepro-list-bounces at lists.celestial.com
> > [mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Rick
> Hane
> > Sent: Wednesday, April 28, 2004 11:37 AM
> > To: filepro-list at seaslug.org
> > Subject: Why so slow
> > 
> > I asked this question a while back and never solved the problem.  Now
> I have to
> > do so so here I go again,
> > 
> > System... Win 2000Pro network, filepro 4.05 16 user (with quickstart
> runtimes).
> > All workstations have either Win NT or Win 2000Pro installed.  
> > They also have the full fp directory on each workstation.  The filepro
> directory
> > resides on the server in a shared folder called Filepro.
> > 
> > to be clearer the path on the server is D:\Filepro\filepro and
> D:\Filepro\fp
> > 
> > Situation... All the workstations run with acceptable speed and have
> for years.
> > Now I wanted to set up the server to be usable as an input station as
> well.  The
> > reason (which has nothing to do with the problem) was that the owner
> wants to
> > access the sustem at night from home via terminal services. I added my
> fp.bat to
> > D:\ and off I went. (sample of file listed below)
> > 
> > Problem... Every input be it a menu selection or input in a file takes
> > (literally) 5 - 9 seconds to either execute or display on the screen.
> Again the
> > workstation at the same time work great.  I am going nuts.  In my 20+
> years
> > working with filepro I have never seen this.
> > 
> > Sample of fp.bat (located in D:\)
> > set PFNET=ON
> > set PFSYNC=ON
> > set PFDSK=D
> > set PFPROG=D:
> > set PFDATA=D:
> > set PFDIR=\filepro
> > set PFCMARK=80
> > set PFRETRY=20
> > p dbs
> > cd\
> > cls
> > 
> > Please help before I go nuts. (more than I am)
> > 
> > Thank you,
> > Rick Hane
> > Yore Software
> > Email: yoresoft at hotmail.com
> > Deluxe Stitcher Company Inc.
> > Url:www.deluxestitcher.com
> > Email: rhane at deluxestitcher.com
> > 
> > _________________________________________________________________
> > FREE pop-up blocking with the new MSN Toolbar - get it now! 
> > http://toolbar.msn.com/go/onm00200415ave/direct/01/
> > 
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> > 
> > 
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> > 
> 
> -- 
> Bill Vermillion - bv @ wjv . com
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Thu, 29 Apr 2004 14:09:59 -0400
> From: Jeff Harrison <Jeff.Harrison at Epixweb.com>
> Subject: RE: Dreport & rreport
> To: "'gcc at optonline.net'" <gcc at optonline.net>,	'Filepro 2 List'
> 	<filepro-list at lists.celestial.com>
> Message-ID:
> 	<827C6DC5D4BA11449AD6412A99F1903E0B67E74D at tpa-mail.epix.local>
> Content-Type: text/plain;	charset="iso-8859-1"
> 
> Richard Kreiss wrote:
> 
> > Pst_hed only need to run once.  This routine prints 15 
> > address labels from the
> > same record.
> > Line 13 tests the counter and ends the program when it gets 
> > to "0". Otherwise
> > line 14 executes
> > And the loop is repeated.
> > 
> > My problem is on the first time this system called program 
> > runs, the lookup
> > fails as the record is not found.
> > If the same selection from the browse lookup is made again, 
> > the record is found
> > and the values posted.  Al succeeding records selected will 
> > post correctly.  
> > 
> > If I run a report, printing the orders listed in the browse, 
> > first, everything
> > works fine. 
> > 
> > The above only happens in rreport; dreport runs correctly each time.
> > 
> 
> 
> Sorry, I missed your if statement because it came before the line
> number.
> >          If: ct = "0"
> >    13  Then: END
> 
> You may want to check out Bob Stockler's processing posting program... 
> 
> At any rate, since the initial lookup fails when it should not, I would
> suspect the process that runs prior to this code - if it first creates
> the
> header record, and then you do this process to update it, make sure that
> the
> lookup is closed before you do your system call.
> 
> Good Luck.
> 
> Jeff Harrison
> jeff.harrison at epixweb.com
> 
> Author of JHExport and JHImport - The fastest and easiest ways to
> generate
> code for filepro exports and imports.  Demos available upon request.
> 
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Thu, 29 Apr 2004 14:12:59 -0400
> From: Joe Chasan <joe at magnatechonline.com>
> Subject: Re: Updating one file from within another
> To: filepro-list at seaslug.org
> Message-ID: <20040429141259.A7389 at magnatechonline.com>
> Content-Type: text/plain; charset=us-ascii
> 
> On Wed, Apr 28, 2004 at 04:04:51PM -0400, Vicky Prigg wrote:
> > I would like to, while in one file, open up a new record in another
> file
> > and be able to post data to it and then update the new record with the
> > rest of the data that I need.  Right now, I am using lookup to a free
> > record and posting the data over.  I used a SYSTEM command to take me
> to
> > the screen in the other file.  I can't use POPUP UPDATE because I need
> > some input processing to take place in the lookup file.  My problem
> is,
> > I can't tell the SYSTEM command to go into that record that I just
> > created from the lookup.  The SYSTEM command just takes me to index
> > selection using the -xi flag.  I can't even use a saved selection set
> > because the value of the field changes with every record.
> 
> you should capture the record # (or some other unique key) when you 
> create the record.
> 
> when going into the second file via system command, pass the record
> # (or other unique key) along on the command line via -r, -rw, -rx,
> -ry, or -rz (these will correspond to system variables @pm, @pw, @px,
> @py, and @pz, respectively.)
> 
> in the second file, use @menu processing and if that value is set in the
> @pm/@pw/@px/@py/@pz - whichever you decide to use, use the "lookup -
> r=(that
> record #" to put yourself directly onto that record - you can take it 
> further and put yourself into update as well as force exit from the file
> 
> when done if you want.
> 
> note - your selection set idea wasn't bad - you can still do that if
> you want by either actually writing the selection set from the first 
> file or most easily by combining the above with a saved selection such
> as 
> "@rn eqf @pm" or "some-key-field-value eqf @pm"
> 
> --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
> -Joe Chasan-                      Magnatech Business Systems, Inc.
> joe at magnatechonline.com           Hicksville, NY - USA
> http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Thu, 29 Apr 2004 14:16:30 -0400
> From: Bob Stockler <bob at trebor.iglou.com>
> Subject: Own Messages on List [was: Re: DECLARE EXTERN]
> To: filePro mailing list <filepro-list at seaslug.org>
> Message-ID: <20040429181630.GC4935 at trebor.iglou.com>
> Content-Type: text/plain; charset=us-ascii
> 
> On Wed, Apr 28, 2004 at 10:29:13PM -0400, Jeff Harrison wrote:
> | 
> | BTW I'm not seeing my own messages on the list now.  Is it just me, or
> is
> | the list down?
> 
> I don't see mine either.  (I just checked the Mailing List
> web site,and I'm supposed to receive them.)
> 
> Bob
> 
> -- 
> Bob Stockler - bob at trebor.iglou.com
> Author: MENU EDIT II - The BEST Creator/Editor/Manager for filePro User
> Menus.
> Fully functional (time-limited) demos available by email request
> (specify OS).
> 
> 
> ------------------------------
> 
> Message: 6
> Date: Thu, 29 Apr 2004 14:06:10 -0400
> From: "Jay R. Ashworth" <jra at baylink.com>
> Subject: Re: Own Messages on List [was: Re: DECLARE EXTERN]
> To: filePro mailing list <filepro-list at seaslug.org>
> Cc: Bob Stockler <bob at celestial.com>
> Message-ID: <20040429140610.C30389 at cgi.jachomes.com>
> Content-Type: text/plain; charset=us-ascii
> 
> On Thu, Apr 29, 2004 at 02:16:30PM -0400, Bob Stockler wrote:
> > On Wed, Apr 28, 2004 at 10:29:13PM -0400, Jeff Harrison wrote:
> > | BTW I'm not seeing my own messages on the list now.  Is it just me,
> or is
> > | the list down?
> > 
> > I don't see mine either.  (I just checked the Mailing List
> > web site,and I'm supposed to receive them.)
> 
> FWIW, I *am* seeing mine.
> 
> I suspect part of this comes from the fact that the celestial address
> processes much slower than the seaslug address, and many people carbon
> the sender.  Y'all do the math.  :-)
> 
> Cheers,
> -- jra
> -- 
> Jay R. Ashworth
> jra at baylink.com
> Member of the Technical Staff     Baylink
> RFC 2100
> The Suncoast Freenet         The Things I Think
> Tampa Bay, Florida        http://baylink.pitas.com             +1 727
> 647 1274
> 
>         "They had engineers in my day, too."  -- Perry Vance Nelson
> 
> 
> ------------------------------
> 
> Message: 7
> Date: Thu, 29 Apr 2004 13:20:43 -0500
> From: "Rick Hane" <yoresoft at hotmail.com>
> Subject: Re: Why so slow
> To: ras at anzio.com
> Cc: filepro-list at seaslug.org
> Message-ID: <BAY17-F1871yEXUIEAO000de250 at hotmail.com>
> Content-Type: text/plain; format=flowed
> 
> Hi Bob,
> 
> Sorry about the confusion.  It is slow only when using "b) the console,
> when 
> used directly".
> 
> In all other cases including at night via Terminal Services speed is ok.
> 
> In know it doesn't make sense and is driving me nuts.
> 
> Thank you,
> Rick Hane
> Yore Software
> Email: yoresoft at hotmail.com
> Deluxe Stitcher Company Inc.
> Url:www.deluxestitcher.com
> Email: rhane at deluxestitcher.com
> 
> 
> >From: Bob Rasmussen <ras at anzio.com>
> >To: Rick Hane <yoresoft at hotmail.com>
> >CC: filepro-list at seaslug.org
> >Subject: Re: Why so slow
> >Date: Thu, 29 Apr 2004 10:40:54 -0700 (PDT)
> >
> >I'm not clear. Is it slow on:
> >
> >a) the workstations?
> >
> >b) the console, when used directly?
> >
> >c) coming in from home using Terminal Services?
> >
> >Also, what more can you tell us about the Terminal Services setup?
> >
> >Regards,
> >....Bob Rasmussen,   President,   Rasmussen Software, Inc.
> >
> >personal e-mail: ras at anzio.com
> >  company e-mail: rsi at anzio.com
> >           voice: (US) 503-624-0360 (9:00-6:00 Pacific Time)
> >             fax: (US) 503-624-0760
> >             web: http://www.anzio.com
> 
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar - get it now! 
> http://toolbar.msn.com/go/onm00200415ave/direct/01/
> 
> 
> 
> ------------------------------
> 
> Message: 8
> Date: Thu, 29 Apr 2004 14:25:47 -0400
> From: Jeff Harrison <Jeff.Harrison at Epixweb.com>
> Subject: RE: Own Messages on List [was: Re: DECLARE EXTERN]
> To: 'Bob Stockler' <bob at trebor.iglou.com>,	filePro mailing list
> 	<filepro-list at seaslug.org>
> Message-ID:
> 	<827C6DC5D4BA11449AD6412A99F1903E0B67E74E at tpa-mail.epix.local>
> Content-Type: text/plain;	charset="iso-8859-1"
> 
> Bob Stockler wrote: 
> > 
> > On Wed, Apr 28, 2004 at 10:29:13PM -0400, Jeff Harrison wrote:
> > | 
> > | BTW I'm not seeing my own messages on the list now.  Is it 
> > just me, or is
> > | the list down?
> > 
> > I don't see mine either.  (I just checked the Mailing List
> > web site,and I'm supposed to receive them.)
> > 
> > Bob
> > 
> 
> I'm seeing them now :-)
> 
> Jeff Harrison
> jeff.harrison at epixweb.com
> 
> Author of JHExport and JHImport - The fastest and easiest ways to
> generate
> code for filepro exports and imports.  Demos available upon request. 
> 
> 
> ------------------------------
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
> End of Filepro-list Digest, Vol 3, Issue 70
> *******************************************
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan-                      Magnatech Business Systems, Inc.
joe at magnatechonline.com           Hicksville, NY - USA
http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264



More information about the Filepro-list mailing list