-nl lookup option

[Craig Tooker]

Is English a second language for you?

I've always wondered.

On 08/26/15 16:37, Richard Kreiss via Filepro-list wrote:
> This is a programming approach question:
>
> For each person in a database you have the following 3 fields.
>
> Accounting code (4,.0) - lowest number is 1000 and values in the 9000 range are reserved.
> Each person is coded with an Accounting number and a person number (5,.0) starting at 10000.
>
> Master code field is accounting Code-person number (NNNN-NNNNN)
>
> Index K is built on the master code.
>
> When a new person is added, the accounting code is entered and the program then does a lookup using index K -nl
>
> The lookup value used currently is lv="NNNN-99999" and get the highest value for NNNN-NNNNN.  A mid statement get the person code and adds one to it. This works nicely.
>
> However, would it be better to use:
>
> Assume that the Accounting Code is 1234
> AC="1234"+"1"
> PC="00000"
> Lv="1235-00000"
>
> Which is better coding or are they the same?
>
> Richard Kreiss
> GCC Consulting
>
>
>
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>