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 _______________________________________________ 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/sn1pr10mb0462c5454db49142518db6a0d2...@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.
