Doug,

I was trying to find which of 400+ tables might contain this issue without having to manually go thru each table and do what you suggest on every field that should not allow a null value. I was hoping that there is a better way to see if I could possibly have this issue.

Thanks,
Mike

----- Original Message -----
From: Doug Chamberlin
To: firebird-support@yahoogroups.com
Sent: Wednesday, April 01, 2009 5:19 PM
Subject: {Disarmed} Re: [firebird-support] How can I find a record in a table that has a null value where the field does not allow a null value?


SoftTech wrote:
> 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?

1. Change the field back to allow nulls.
2. Get rid of the nulls.
3. Change the field again to not allow nulls.




[Non-text portions of this message have been removed]