Subject RE: [IBO] Data Aware components - question
Author Helen Borrie
At 09:56 AM 19/10/2004 +1000, you wrote:

> > To make a dataset "editable" you must do two things:
> >
> > 1) set RequestLive true (or, alternatively, provide custom
> > XXXSQL properties that make a non-updatable dataset updatable)
> >
> > and
> >
> > 2) set correct KeyLinks
> >
> > You might have set KeyLinksAutoDefine to true in expectation
> > that the dataset would find its own KeyLinks automatically.
> > In the case of a simple query of one table, that includes the
> > columns of the primary key, this is what happens. But if
> > your SQL doesn't include the key in the set, or if the query
> > has a join, Autodefine doesn't work and you must set KeyLinks
> > yourself. They also must be correct, i.e. uniquely identify
> > one record in the buffer.
> >
> > Helen
>I understand. However, is possible to set the RequestLive to True, when
>working with multiple tables, join, etc, so that the TIB_Edit components
>would allow the application user to edit the contents of them? (I am aware
>that I will have to set the KeyLinks when operating on multiple tables,
>join, etc).

Yes, under one special set of conditions. If you have a join set and you
only want to update one of the underlying tables, you can set RequestLive
true AND set the name of the table to be updated in the KeyRelation
property. Provide the KeyLinks are perfect, IBO will then automatically
construct the correct XXXSQL statements for the DML.