Subject | Re: [IBO] "Live" Query Conditions List |
---|---|
Author | Helen Borrie |
Post date | 2004-10-12T02:35:55Z |
At 02:06 AM 12/10/2004 +0000, you wrote:
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
>Where can I find a list of conditions under which and IBOQuery can beThere is no "list". Provided the KeyLinks are correct, the only type of
>made "live" using RequestLive?
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