Subject Re: [ib-support] Re: Cannot Modify a Read Only Dataset
Author Helen Borrie
At 10:50 PM 13-02-01 +0000, you wrote:
>--- In ib-support@y..., Lucas Franzen <luc@r...> wrote:
> >
> >
> > mss@s... schrieb:
> > >
> > > I have a Delphi TIBDataset component that I am trying to use to
>add a
> > > record to a table. When I open the dataset and try to add a
> > > I get the following error message:
> > >
> > > "Cannot Modify a Read Only Dataset"
> >
> > you didn't set the RequestLive Property to true.
> >
> > Luc.
>There is no RequestLive Property for a Delphi TIBDataset component or
>a TIBQuery component. RequestLive only applies to TQuery.

It's a while since I tinkered with IBX but, as I recall, you are supposed to enable "live" behaviour on a read-only dataset in IBX by putting appropriate statements into the InsertSQL, ModifySQL and DeleteSQL properties. If you open the SQL editor on these properties, IBX is supposed to create a default DML statement for you. At around v. 4.2 beta, this worked reliably only in the TIBDataset class.

This list isn't a Delphi list. It sounds as if it would be helpful for you to join the Borland newsgroup for IBX users...and you might find you will get more satisfactory behaviour from a later beta version - I think they are up to beta 4.4 now. You can get the beta releases and the release notes from CodeCentral.


All for Open and Open for All
InterBase Developer Initiative ยท