-------------- Original message ----------------------
From: johnf <[EMAIL PROTECTED]>
> On Sunday 17 February 2008 10:31:11 am Adrian Klaver wrote:
> > -------------- Original message ----------------------
> > From: johnf <[EMAIL PROTECTED]>
> >
> > > On Sunday 17 February 2008 10:01:24 am Adrian Klaver wrote:
> > > > I know about using the following to create a new child record when a
> > > > new parent record is created: NewChildOnNew
> > > > NewRecordOnNewParent
> > > >
> > > > The problem I am having is determining how to add a new child record in
> > > > a dGrid where a parent record already exists.
> > > >
> > > > --
> > > > Adrian Klaver
> > > > [EMAIL PROTECTED]
> > >
> > > self.Form.new('TableName') in this case the TableName should be the
> > > child.
> > >
> > >
> > >
> > > --
> > > John Fabiani
> >
> > Thanks, that worked though it brought up something else I a have meaning to
> > ask about. Is there a property/method of making a no value in a string
> > field equal to None/NULL instead of ''? Besides using Defaults.
> >
> >
> > --
> > Adrian Klaver
> > [EMAIL PROTECTED]
>
> Adrian,
> Something is wrong here. It is my understanding the Dabo displays NULL's
> as "<None>"???? I think it does with my stuff anyway. Where do you see
> blanks? ''=blank Right?
>
>
>
> --
> John Fabiani
>
It displays '<None>' when there is a NULL in the field. My problem comes when I
create a new record. If I don't enter a value in a field the value passed to
the INSERT
statement is '' for a string column, 0 for a number column and False for a
boolean.
This causes problems with the DEFAULT values I have set up in the Postgres
database.
Instead of the column receiving a NULL value and filling in the correct default
it receives
an invalid value. I am trying to figure out a way to undo this editorializing
without having
to specify DEFAULTS for the fields in DABO as they already exist in the
database.
--
Adrian Klaver
[EMAIL PROTECTED]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
