Re: Problem with coltype in syscolumns

Posted in 1995

Vadim J. Nikitin — 20 Jun 1995 08:44:03 GMT — source: Informix-list mailing list archive (1991-1998)

Puru Balakrishnan (pbalakrishnan@symantec.com) wrote: : This query performed on db-access returns the correct results as: : colname coltype collength : field1 256 10 : field2 2 4 : A value greater than 256 indicates it does not allow nulls. : - The same query when performed from a client using ESQL/C yields: : colname coltype collength : field1 0 10 : field2 2 4 : As a result, I cannot figure out if the column allows null values. Check the type of "coltype" in your ESQL/C program. Maybe it's char ? WBR, Vadim J. Nikitin