Nope, MSSQL guy. ;-) VFP does that for you when you turn off nulls. It looks at the data type and puts in a default value.
Jeff, you will be able to script those structure updates using ALTER TABLE. Definitely faster than using the UI to MODI STRU. -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Wednesday, April 15, 2015 3:01 PM To: [email protected] Subject: Re: Nulls On Wed, Apr 15, 2015 at 1:58 PM, Jeff Johnson <[email protected]> wrote: > These are VFP tables and I don't want to re-export the tables from SQL > Server. I want to keep the tables as they are but make the fields not > accept nulls. Every field in every table is marked to accept nulls. > > ------------- You will have to REPLACE the null with a "proper" value first before you can say no nulls. Every column of every table that is. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ 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/sn1pr10mb0462f33aabceefe95195f22bd2...@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.
