Automatic Assignment Of NOT NULL Defaults

[Nathan Wild 3]

I am working with a table that has a large number of fields which are ALL set up as NOT NULL.  90% of these are unused, but need to be populated when inserting new records.  Is there an easy / automatic was to tell FD to automatically populate '' and 0 values as appropriate for data type when inserting new records?

[Attila Kovacs 629]

Can't you just define defaults for those fields in the db?

Edited February 8, 2019 by Attila Kovacs

[Nathan Wild 3]

Oh yes, of course...  I was just hoping that there was a way to do this somewhat more automatically...

[Sherlock 663]

Stored Procedures? The work involved is the same. The DB can't guess what default value you prefer.