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