Returned Value on Lookup Stage

Marley777 · Post by **Marley777** » Mon Nov 14, 2005 10:00 am

I have a situation where I need to do two separate lookups which will return new values from a table if the key is found. If both lookups fail, I already have what I need and no further processing is necessary. If one or both of the lookups were successful then I need to do some additional processing with what was found in the lookup table.

My question is what value is in the lookup table non-key value(s) if the lookup fails? It does not appear to be null since I based subsequent logic on null values.

Thanks in advance.

als110 · Post by **als110** » Mon Nov 14, 2005 11:40 am

I depends what the return value data type is. could be null or in some cases it is zero

Marley777 · Post by **Marley777** » Mon Nov 14, 2005 11:44 am

The data type is integer.

Marley777 · Post by **Marley777** » Mon Nov 14, 2005 11:58 am

Looks like it is returning zeroes. Thanks for the help.