Subject Re: [IBO] "Live" Query Conditions List
Author Helen Borrie
At 02:06 AM 12/10/2004 +0000, you wrote:


>Where can I find a list of conditions under which and IBOQuery can be
>made "live" using RequestLive?

There is no "list". Provided the KeyLinks are correct, the only type of
query that can be made "live" with RequestLive is a non-grouped query over
a single table.

As a rule of thumb, if you set RequestLive true and your KeyLinks are
correct, and you can't get an updatable set, then you need to write custom
SQL for your your DML.

Non-updatable sets (statements) are: any with joins in them (though you
can make one table "live" by using KeyRelation); statements with GROUP
BY; non-updatable views; selectable SPs; any statements, even on a single
table, which output expressions instead of database columns...etc. I
mention the last one, because I sometimes encounter designs where the
developer decided to use column aliases for everything, in order to save
the "trouble" of having to assign human-readable DisplayLabels for
grids. NOT a sound design principle. :-))

Helen