It worked in IBO 3.6.

IB_Query:

SELECT ID, ACCID
, (select account from account a where a.id=m.ACCID) as ACCOUNTNO
, STATUS , CREATID
, ACCID1
, ACCID2
, AMOUNT
, RAMOUNT
, RATE
FROM account
join conversion m on account.id=m.accid
where uid=:UID and install=:INST
for update

In grid I don't show ACCID, and show ACCOUNTNO.
When I insert new records, in AfterInsert() I set ACCID=3. In form I have
LookupCombo where I can change account.
If I do it, then the account number appears in the grid. If I just press
Insert and Post, then the grids ACCOUNTNO field is empty, but ACCID field in
form shows correct value. If I press RefreshAll button, then the grid starts
to show the missing values.
What am I missing here? Should i force a refresh after insert?



Riho-Rene Ellermaa
senior programmer
Hansabank