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)

KeyLinks:
ID

JoinLinks:
A.BID=B.ID

From within IB_Query the auto-creation of the UpdateSQL produced:

UPDATE A
SET ID=:ID,
NAME=:NAME
WHERE ID=:OLD_ID

and I modiefied this to:

UPDATE A
SET ID = :ID,
NAME = :NAME,
BID = :BID
WHERE ID=:OLD_ID

This gives the error message that the count of columns does not equal the count
of read/write columns.

Does this mean that I must have BID in the SELECT statement and then set its
visibility to False?
--
Raymond Kennington
Programming Solutions
W2W Team B