Sort/Selection processing

Richard Hane yoresoft at sbcglobal.net
Wed Jun 16 12:41:36 PDT 2010


[ sorry top posted ]

Harold,

For years I have allowed users to access Word, Excel, Notepad(++), Internet Explorer, etc from with in fp.  Note I do this from the review mode not while in input.  (Just never tried it).

Here is the Excel command I use

@key+ : : input popup f "Enter filename or leave blank for new file "  (Used if user is to give filename)
@key+ : : f="shopsch.xls"{""  (System used filename)

: : then: mf="c:\programs files\microsoft office\office\excel.exe"<f

Note that in the above neither f nor mf are defined

Running using fp (5.0.15) on a Windows 2003 server network

Hope this helps

Rick Hane
Controller
Deluxe Stitcher Company Inc
www.deluxestitcher.com



________________________________
From: John Esak <john at valar.com>
To: Harold <haroldef at sbcglobal.net>
Cc: list filePro mailing <filepro-list at lists.celestial.com>
Sent: Wed, June 16, 2010 1:46:21 PM
Subject: RE: Sort/Selection processing

It sounds like you might still be in filePro when you're trying to open the
file. If so, you must CLOSE it first.  So issue a CLOSE statement and see if
you cn then open the file first. 

John

> -----Original Message-----
> From: Harold [mailto:haroldef at sbcglobal.net] 
> Sent: Wednesday, June 16, 2010 12:01 PM
> To: john at valar.com
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Sort/Selection processing
> 
> On 6/15/2010 3:51 PM, John Esak wrote:
> >
> > Yes, I realized right away that @ts wouldn't have a meaning 
> other than Total
> > Records Processed, not Total Records Selected.  I think it 
> *would* be useful
> > in this context.  Not *real* useful... But somewhat, 
> maybe... Sometimes...
> > Perhaps. Oh, okay, it's pretty much not to useful a thing 
> to know, other
> > than to just know it? Since it has no relation to how many 
> you actually
> > select, you couldn't use it for much of anything.
> >
> > John
> >
> 
> Hi John,
> 
> I am still working on my problem--I can create the CSV file, 
> but haven't been able to 
> open the CSV file while in filepro, using Excel, after the 
> CSV file has been created.
> 
> I use @ts to see how many records have been selected, and as 
> each record has been 
> sent to the CSV file I increment a variable field rn.  When 
> rn is equal to @ts I try 
> to open CSV.
> 
> To prove that @ts is the number of records selected I have 
> created the JPG file 
> attached.  Note at the bottom left where it shows @ts, which 
> contains the number of 
> records selected, which is that same number as that above.
> 
> Take Care,
> 
> Harold
> 
> >
> >
> >> -----Original Message-----
> >> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> >> Sent: Tuesday, June 15, 2010 3:49 PM
> >> To: john at valar.com
> >> Cc: filepro-list at lists.celestial.com
> >> Subject: Re: Sort/Selection processing
> >>
> >> On 6/15/2010 2:12 PM, John Esak wrote:
> >> [...]
> >>> I will assume that @ts has no value either on the -v table.
> >> Although, who
> >>> knows (besides Ken :-) maybe it does. In which case, you
> >> could set an
> >>> incrmenting counter for every record encoutnerd selected or
> >> not and when @ts
> >>> equalled this counter, you'd be done with the -v processing.
> >> [...]
> >>
> >> I'd have to check is @TS has any value during sort/select
> >> processing.  But,
> >> even if it did, what would it mean?
> >>
> >> Consider this:
> >>
> >> I hand you my Rolodex, and ask you to pull out all the
> >> clients from New
> >> York.  Part-way through, I ask you "how many New York clients
> >> are in my
> >> Rolodex, and have you gotten all of them yet?"
> >>
> >> --
> >> Kenneth Brody
> >>
> >
> > _______________________________________________
> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100616/8ff2f5c0/attachment.html 


More information about the Filepro-list mailing list