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