In my innocence, I wonder why you want to disallow NULLs? They are, IMHO, the best way to hold unknown or irrelevant column values.
Laurie On 15 April 2015 at 20:31, Richard Kaye <[email protected]> wrote: > Different answers to different questions, my friend. Yes, VFP prior to 8 > allowed you to have ambiguous grouping. As long as you were willing to > accept that the non-aggregated, non-grouped column results were potentially > meaningless at best then it wasn't something to worry about. In Jeff's > case, he is not running a query; he is altering existing table structures. > The column types themselves are not ambiguous so a numeric column > previously supporting nulls will get a zero. Booleans go false and so on. > > -- > > rk > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Stephen Russell > Sent: Wednesday, April 15, 2015 3:25 PM > To: [email protected] > Subject: Re: Nulls > > VFP allows you to not "group by" properly in a query with an aggregate as > an output. Sometimes you want to identify what the absence of value is in > a system. A 0 may be valid measurement for one test yet you should never > average that same data with a 0. That column may be AttemptsMade. > > > On Wed, Apr 15, 2015 at 2:12 PM, Richard Kaye <[email protected]> > wrote: > > > 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 > > [excessive quoting removed by server] _______________________________________________ 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/CAMvTR9eM0KeiuR_-=emq959syhfrlm2+xxowa4gid1g_jof...@mail.gmail.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.
