[Opensource] JoinedDataObject working with DBMaint

[Ian at satb]

I've been trying out the new JoinedDataObject and it is working well,
accessing joined objects through DBMaint is great.  I think it is a massive
improvement and a real time saver.

I've encountered the following things in using JoinedDataObject with
DBMaint:

1. To do a successful add operation, you have to manually enter each
individual foreign key field in the form for each foreign joined object, is
it possible to automatically set it to the value of the local key field?
e.g. If the local DBObject has a local key which is an auto-inc field, after
the add of the local object, is there a mechanism in DBMaint add routine to
do:

link=getField("local.localKey");
setField("foreign.foreignKey",link);

Has anyone encountered a similar thing to this ?

2. If I have an addDetail call in the local DBObject, when you try and
update the JoinedDBObject through DBMaint, you get an error "field name must
be of format ....
etc" and it asks for the dot naming syntax.  I took out the addDetail call
from the
local DBObject and then updates worked fine.

3. I could not get add/updates of BlobFields in MediaDBObjects working, the
data fields in the same MediaDBObject work fine but the JoinedDataObject
can't seem to access any of the Blob fields. If you try and click on the the
view link, you see an error "blob viewing is only possible under JDBC
dataobjects".  When you give DBMaint the MediaDBObject directly it works
fine, only when you give DBMaint the JoinedDataObject does it hiccup. Is
there a way around this?

thanks

---------------------------------------------
Ian Morris
satellite-b ltd
Design & Innovation for Network Services
---------------------------------------------