Steve,

Did you set up InsertSQL, EditSQL, DeleteSQL ? You will need it for joins.
Even if you set requestlive to true, ibo will turn it false if it doesn't
know how to work the join.

You should also check IBO Default values (Property DefaultValues).

And since you are working with TIBOQuery, you must also take care with
'FieldOptions' properties.

Artur

----- Original Message -----
From: "Steve Harp" <steve@...>
To: <ibobjects@yahoogroups.com>
Sent: Monday, September 29, 2003 7:38 PM
Subject: [IBO] Calculated fields with TIBOQuery


> Hi All,
>
> I'm trying to use a Boolean calculated field with an TIBOQuery. I can
> create the field just fine, but I can't edit it even thought I've set
> RequestLive = True for the query. I'm trying to do a simple join of 2
> tables and add a Boolean field so that I can display the result set in a
> grid and allow the user to toggle the Boolean field on/off to
> select/deselect the records. Also, I need the field to default to false;
> now it defaults to NULL. I don't need to edit any of the natural fields
in
> the result set; only the calculated field.
>
> Will this work and, if so, how do I do it?
>
> Thanks,
> Steve