-------------- Original message ----------------------
<Snip>
> > >
> > > The new dCursorMixin does fill the fields with None values. The problem
> > > it also fills the link field. I tested entering a new record in a dGrid
> > > that holds a child bizobj. The link field was set to None(<None>) and I
> > > could not change it manually to the correct value. I could not go any
> > > further. One question is what the presence of None(NULL) values will do
> > > to fields with a constraint of NOT NULL and a default value? I will be
> > > away from the computer for most of the day so I will not be able to do
> > > any testing until this afternoon/evening(PST).
Got a chance to test. It is almost there. The new dBizobj code handles the link
key issue.
I created a new record and only the values I entered where inserted. See
Postgres log below:
statement: insert into "public"."projection" ("sub_method", "p_item_no",
"c_id", "qty", "year", "method") values ('none', 1, '35RF', '10', '2008',
'seed')
The problem is that the transaction does not commit. When I move off the record
I get the
confirmation dialog asking it I want to save my changes. If I answer yes I get:
statement: update "public"."projection" set "sub_method" = 'none', "p_item_no"
= 1, "line_id" = 12143, "c_id" = '35RF', "qty" = 10.0000, "trial" = NULL,
"link_key" = NULL, "year" = '2008', "proj_note" = NULL, "method" = 'seed',
"dabo-tmpKeyField" = NULL, "item_key" = NULL, "pot_ct" = NULL where
"public"."projection"."line_id"=-1
postgres-production-2008-02-18 16:05:30.828
PSTERROR: column "dabo-tmpKeyField" of relation "projection" does not exist at
character 218
Note the dabo-tmpKeyField field in the Insert statement.
--
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]
