David Almada wrote on 2013-01-13: > I created a VIEW connected to a MicroSoft SQL 2005 Database Table. I then > created a form with the next/previous/add/edit. buttons. > > > I fixed the VIEW so that it would update the fields in the sql database. > > > All works great except when I leave a field blank and save and then go back > and go to that record the blank field has "null" in it. > > > I know why this is but how do I fix it in the form so that it does not do > it? > > > What else can I expect while learning SQL and FoxPro 9? > > > Do I have to set a default date in my start up program like > > > _startdate"01/01/1901 01:01:01" > > > ?? > > > David Almada >
David, I don't work with an SQL backend enough to give you the "what else to expect". I do know that a date field in SQL cannot be blank. It either has a valid date, or it is NULL. You can use the textbox.nulldisplay property to show a blank date with " / / "(without the quotes). Tracy Pearson PowerChurch Software _______________________________________________ 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/[email protected] ** 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.
