Subject RE: [ib-support] Detecting a Not NULL field in a select
Author Ann W. Harrison
At 03:41 PM 11/22/2002 +0100, Ignacio J. Ortega wrote:
>Paul,
>
>Yes, i know that, but to my understanding, sqlind is used when the data
>is effectively NULL, but not when the underliying field has a "Not Null"
>constraint, my question was badly formulated, i know sqlind and the
>sqltype+1 trick..

If the datatype is odd, the column is nullable. If the indicator
is -1, it's null.

Regards,

Ann
www.ibphoenix.com
We have answers.