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?

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.

>
> >Will displaying a COMPUTED field that is defined like:
> >
> >COMPUTED BY
> > ((SELECT Paddock
> > FROM Paddock JOIN Animal
> > ON (Paddock.ID = Animal."Paddock ID")
> > WHERE Animal.ID = "Animal ID"
> >
> >will IBO (or Firebird) generate an exception because "Animal ID" is NULL
> >when the dataset goes into
> >Insert mode?
>
> Not if you attribute it as COMPUTED.
>
> Helen

Thanks, Helen.
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)