Raymond Kennington wrote:

>
> Helen Borrie wrote:
> >
> > At 11:41 PM 7/04/2003 +0930, you wrote:
> > >Helen Borrie wrote:
> > > >
> > > > At 10:39 PM 7/04/2003 +0930, you wrote:
> > > > >Consider a table that has several fields followed by a COMPUTED field.
> > > > >
> > > > >1. With a new record all fields that don't have defaults are NULL.
> > > > >(a) What do COMPUTED fields display in grids and IB_Edits?
> > > >
> > > > The computed value that is output by the query.
> > > >
> > > > >(b) Are COMPUTED fields automatically updated in the grid and IB_Edits?
> > > >
> > > > Only when you refresh the dataset - because they are *output* values.
> > >
> > >Will this work when in Insert mode and the user leaves the field that the
> > >COMPUTED field uses and
> > >before all fields are entered and before posting the record?
> >
> > Will what work? The field is not computed on the client.
>
> Will refreshing upon exit of the field that is used for calculating the COMPUTED field?

Suppose a field F is exited that a COMPUTED field CF in the same table depends upon.

In OnExit of the control for F:

(a) Will refreshing the query keep the currently-entered value in F?

(b) Will refreshing the query update FC?

For example:

1. Enter Cost;
2. Exit CostIB_Edit control (or grid field for Cost);
3. In OnExit of the CostIB_Edit control issue a refresh of the dataset in order to display the
computed field;
4. Enter another field for editing.

--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)