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 > -----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 > > [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/cajidmyjwmlc9gyfw-kzymx1nkgqjqh_erzxkuuxvhfqcu1u...@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.
