moved from dabo-user - from a request by Jacek Kalucki who would like a way to
prevent Dabo of passing a field value when inserting or updating a row. Not
passing a field will allow the DB to apply the a default value.
>Ed Wrote:
I think that the way it should work for new, unsaved records is as
follows:
modified: used to determine isChanged(), and included in INSERT.
default: not used to determine isChanged(), but included in INSERT.
blanks: not used to determine isChanged(), and not included in INSERT
Paul wrote:
+1, but we need a better way to flag blanks. I propose defining a string or
class in dabo.db called DaboBlankField or "^^^DaboBlankField^^^". The cursor
fills in the blanks with this value. The UI controls display the proper
rendition of blank in the context of how the control works ("" for textbox, 0
for spinner, etc.)
John wrote:
What about list values - is it possible to have a "^^^DaboBlankField^^^"
value for a list? I use lists for DB values all the time. I see this being
very difficult to work with - the list has to have the value in the list that
is in the DB.
Ed's reply to John
> To be blunt, you don't need to worry about it at all, just the way
>that I'm sure you don't worry about the new record flag value. This is
>why I said that the conversation should be on dabo-dev, not dabo-users.
Ed please always be blunt - I may not be the brightest programmer but I'll
work until the job is done. BTW it's only others that have said to lighten
up on me - not me. Also I believe I can speak for Larry (who is gun shy
these days) who wants your honest opinion too.
Back to the question - but I do account for the new record. I always
include , 0, and None in my list. If I don't the list control complains.
What would be the value of the new key in the list using your suggestion.
Johnf
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message:
http://leafe.com/archives/byMID/[email protected]
