Subject Re: [IBO] how to update field values based on other fields
Author Lester Caine
> I'm an IBO newbie and I'm used to having fields in the Fields Editor of the
> VCL's table and query components, but now I can't seem to find what I'm
> looking for in IBO's query component.
> Say I have 2 fields, Field1 and Field2, and I need to compute the value of
> Field2 based on a formula that uses the value of Field1. I'm looking for
> something like the VCL's OnChange event for fields in the Fields Editor. I
> want Field2 to display the computed value every time Field1 is modified. How
> can I achieve this effect in the native IB query? I've worked up something
> using the OnDataChange event of my query's TIB_DataSource, but is there a
> better way?

I do this sort of thing in the control that I am using to
update 'Field1' - usually in the OnExit so that any
connected stuff is only fired when you change to another
control. It really depends on where the other information is
to be displayed prior to posting to the database.

Lester Caine
L.S.Caine Electronic Services