Updating one file from within another

Thu Apr 29 12:45:41 PDT 2004

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.

Vicky Prigg
Laparkan Trading Ltd.
2929 NW 73rd St.
Miami, FL 33147

-----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
*******************************************