Record Selection in Output Processing

Robert T. Repko (R Squared Consultants) rtr at rsquared.com
Wed Aug 3 19:14:55 PDT 2011


Browse lookup does not work in sort/selection processing, one of the 
many features we have been begging to have for a looong time.

You have to perform a lookup, load the name in to a variable, ask the 
user if that's correct or get the next name.  If the ask for the next 
name you wou;d perform a getnext and look to the lookup until they 
find the name or they quit/abort the lookup.

You could also perform a lookup and load several names in to an array 
to display multiple names at once.  You could use the command listbox 
to display the names.

Believe it or not at 8/3/2011 06:36 PM, Rodgers Hemer said:
>CentOS Linux/filePro 5.6.10
>
>I am creating a report in a file containing work order data using 
>sort/selection processing based on the customer name in the work 
>order.  The persons requesting the report know the customer names 
>but often do not remember the full name that is in the work order 
>record.  I have tried using a lookup based on the name index but I 
>cannot find a combination of commands that will allow a search other 
>than using the complete name instead of the first letter(s) of the 
>name.  For instance, the user would enter "S" or "Smith"  to find 
>"Smith Manufacturing Company" on the browse screen.  I am assuming 
>that the browse screen is available in dreport's sort/selection processing.
>
>I have used sort/selection processing many times and have tried 
>every combination of commands and criteria that I can think of, but 
>I cannot find the way to proceed on a partial name.   Can anyone 
>point out a solution and/or my erroneous assumptions?
>
>Rodgers Hemer
>206.523.2329
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>Subscribe/Unsubscribe/Subscription Changes
>http://mailman.celestial.com/mailman/listinfo/filepro-list

***************************
* Robert T. Repko         *
* R Squared Consultants   *
* 4 Juniper Ave.          *
* Easton, PA 18045        *
* (610) 360-1117 (mobile) *
* (610) 253-0725 (fax)    *
*************************** 




More information about the Filepro-list mailing list