Subject | how to update field values based on other fields |
---|---|
Author | Jane Obenza |
Post date | 2003-01-30T06:11:39Z |
Hi,
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?
TIA
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?
TIA