Subject | How can I find a record in a table that has a null value where the field does not allow a null value? |
---|---|
Author | SoftTech |
Post date | 2009-04-01T20:26:49Z |
Greetings All,
I was just wondering if anyone else has found a way to find any record in
any and all tables in a Firebird database that should not be null, but is.
We all know how we get here. A field is added that allows nulls when first
created and then it is later changed to not allow nulls.
Any ideas on how this could be done or if there is already any tools out
there that will do this?
Thanks,
Mike
I was just wondering if anyone else has found a way to find any record in
any and all tables in a Firebird database that should not be null, but is.
We all know how we get here. A field is added that allows nulls when first
created and then it is later changed to not allow nulls.
Any ideas on how this could be done or if there is already any tools out
there that will do this?
Thanks,
Mike