Just to be clear, are these DBFs created from SQL tables? If so, check the ALTER TABLE...ALTER COLUMN syntax for existing tables where you want to remove NULL support. Unlike SQL, I believe VFP will assign default values when you remove NULL support. Otherwise you may need to do what Stephen mentioned and first update your NULL columns with the appropriate default value.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Wednesday, April 15, 2015 2:44 PM To: [email protected] Subject: Nulls I have a bunch of tables created by exporting from SQL Server and they allow nulls on each field. Is there a way to not allow nulls for an existing table other than unchecking each field? TIA -- Jeff _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/sn1pr10mb0462bdd3327dd980562e8862d2...@sn1pr10mb0462.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
