Jump to content
Nathan Wild

Automatic Assignment Of NOT NULL Defaults

Recommended Posts

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?

Share this post

Link to post

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

Share this post

Link to post

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

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now