index assignments

[Jeff Harrison]

--- On Mon, 10/13/08, Richard Kreiss <rkreiss at gccconsulting.net> wrote:

> From: Richard Kreiss <rkreiss at gccconsulting.net>
> Subject: index assignments
> To: filepro-list at lists.celestial.com
> Date: Monday, October 13, 2008, 9:00 AM
> This is most likely a Ken question, which may have been
> answered in the
> past.
> 
> Lookup on an auto index using 2 fields.  Index primary
> field(master_code) is
> a 10 digit numeric custom edit in for form NNNN-NNNN. Field
> 2(sequesnce) is
> a 2 digit zero fill field.
> 
> If I recall correctly if I create a lookup value
> lv=field1&field2, the value
> lv is a string value(alpha-numeric).
> 
> My question is if the lookup value is
> 
> Lookup foobar k= (master_code & sequence) i=B -nl
> 
> Is sequence considered a numeric value or a string?
> 
> 
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
>   

Hi Richard.  If it is 2 digit, zero fill in your index, this would be considered alpha-numeric by filepro.  So you should use an alphanumeric type for sequence.  I would say that you are always safest to declare your variables with the same edits as are defined for the fields in your index though.

Good Luck.

Jeff Harrison
jeffaharrison at yahoo.com