I don't understand how setting up EditSql will help when I'm only trying to
edit a calculated field. In fact, I don't know what the SQL statement would
look like since a calculated field doesn't really exist on the server.

Ditto for FieldOptions. I don't see how foCaseInsensitive or
foNoPartialCompare would have any effect on a Boolean, calculated field.

Steve

-----Original Message-----
From: Artur Anjos [mailto:artur@...]
Sent: Monday, September 29, 2003 3:07 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Calculated fields with TIBOQuery


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



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/