On 14/01/2013 20:12, Tracy Pearson wrote:
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
Yes there's the nulldisplay property and also set nulldisplay, also
default values - but if you're really used to FoxPro then nulls will
always bite you in the ass - you just have to re-learn.
AndyD 8-)#
_______________________________________________ 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. Report [OT] Abuse:
http://leafe.com/reportAbuse/[email protected]
_______________________________________________
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.
