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