When I uncheck accept nulls VFP does assign a default value to them.
On 4/15/2015 11:58 AM, Richard Kaye wrote:
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:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Wednesday, April 15, 2015 2:44 PM To: profoxt...@leafe.com 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
[excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/552eb543.1090...@san-dc.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.