Reading Selection Sets
Keith' Weatherhead
keithw at ddltd.com
Tue Apr 4 06:02:23 PDT 2006
Doug Luurs wrote:
> When you are running a report, is there a way to get the fields and
> values defined in the selection set you are running currently?
>
> (Short of reading the selection set of course-but that may be different
> due to the person changing the values by hand-which is what I want to
> catch)
>
> Douglas Luurs
> Systems Programmer
> Borisch Mfg Corp
>
> Voice: 616-554-9820 x143
> Fax: 616-554-9180
>
> If replying to this email, please attach whole message for reference. -
> Thank You.
>
> This E-mail, including any attachments, may contain confidential information
> and is intended solely for use by the individual to whom it is addressed.
> If you received this E-mail in error, please notify the sender,
do not disclose
> its contents to others, and delete it from your system. Any
other use of this
> E-mail and/or attachments is prohibited. This message is not
meant to constitute
> an electronic signature or intent to contract electronically.
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
Doug,
This question has been asked or the process attempted so many times
over the years that I cannot believe that it has never been
addressed by TPTB thru all the variations from The Small Computer
Co. to FPTech. I know of know way "to-date" to do this other than
to read the actual Selection Set off the HD. If you know that the
process needs this info, do it in a @once or some early event and
pass the Selection Set name into one of the @p? parameters on the
command line. What would be very hard to do, unless it has happened
lately and I just haven't looked at I haven't had the need is to see
if a new @ system variable already contains the name of the
Selection Set used. The question is can it capture the Set Name if
you manually go thru the Selection Set->Extended Selection and
either enter criteria or Load an Existing Set?
Anyway, now, especially since the 5.x version and having System
Arrays... why can't the current Selection Set, in-use be a System Array?
Why can't a variable be set @SS for example, that contains the
Selection Set name from the command line -OR- Loaded from an
existing set?
Why can't it contain a fixed string that cannot be a normal filename
name, such as '*USER*' if you entered an Extended Set data, but have
not saved it to a file for future reference?
Why is there NOT a command set to build, save, and remove Selection
Sets from within processing? Yes you can do it with file I/O, but
why does FP itself not make it available to the programmer? This
would let you walk the user thru a selection process, store it...
use it thru multiple steps (reports, updates, etc.) and then remove
it when finished... you could do your own naming for the series to
prevent it from hitting any previously existing Set name.
If the example @SS was non-blank, then maybe a @SSDATA array would
exist which would be 13 elements long, just the like Selection
Criteria Screen... the widths are already known... would not be a
big deal to do at all... I would think any FPTECH C-coder would have
MORE than enough ability to implement ! ! !
Feature ver 1 - @SS and @SSDATA
Feature ver 2 - Be able to update @SSDATA and essentially be able to
do the equivalent of a "RESET" command.
The results could be very interesting ! ! !
Regards,
Keith
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Keith F. Weatherhead keithw at ddltd.com
Discus Data, LTD Voice: (815) 237-8467
3465 S Carbon Hill Rd Fax: (815) 237-8641
Braceville, IL 60407 Nat'l_Pager: (815) 768-8098
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
More information about the Filepro-list
mailing list