I have no intention of enhancing the this but I would accept additional user
contributions in this area. This feature was user contributed to start with.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Raymond Kennington" <progsol@...>
To: "IBObjects" <ibobjects@yahoogroups.com>
Sent: Tuesday, December 24, 2002 7:25 PM
Subject: [IBO] Creating update code automatically fails to do so correctly
with joins


> 2 tables:
>
> A
> ID NOT NULL
> NAME NOT NULL
> BID NOT NULL REFERENCES B(ID)
> PrimaryKey: ID
>
> B
> ID NOT NULL
> NAME NOT NULL
> PrimaryKey: ID
>
> IB_Query (LiveEdit=True):
>
> SELECT A.ID, A.NAME, B.NAME
> FROM A JOIN B ON (B.ID=A.ID)
>
> >From within IB_Query the auto-creation of the UpdateSQL produced:
>
> UPDATE A
> SET ID=:ID,
> NAME=:NAME
> WHERE ID=:OLD_ID
>
> KeyLinks:
> ID
>
> JoinLinks:
> A.BID=B.ID
>
>
> The TIB_Grid for this query then doesn't allow one to get to the B.NAME
field in
> order to enter a name and immediately displays an error message indicating
that
> a non-nullable field is null.
>
> Is this a bug?
>
> Can this be made to work correctly?
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B