An IB_Query contains something like:
(Ignore imprecise syntax)

SELECT ID, F1, (SELECT Total FROM Calc_Total(ID)) as TotalUsed
FROM TableA

I have set KeyLinks and Insert/Update/Delete SQL statements in the IB_Query.

The values display correctly when the query is opened.

After inserting a new row, the field determined by the Calc_Total SP are not
updated and appear as NULLs.

AutoCommit is set to True.

I have tried setting CommitAction to caRefresh and caInvalidateCursor, because
I don't know what effect they have -- and in this case they had none.

If IB_Query.Refresh(); is placed in the AfterPost event, the calculated field
appears with correct values for each row.

What is the proper way of refreshing the calculated field after posting the
record, and not necessarily committing the transaction?
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)