C API field type values are inacurate - help

2007-04-04 Thread Alan Nilsson
I have noticed that when using the C API that in certain instances the field 'type' constant is not correct. When a value is returned from a 'TEXT' type field it is reported as a 'BLOB' type. I realize that a TEXT is an extension of a BLOB, but, since they are different types according to

finding NULL records

2006-10-30 Thread Alan Nilsson
I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set when there are in fact records that have a null value

Re: finding NULL records

2006-10-30 Thread Alan Nilsson
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote: [snip] I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set