Subject Re: [IBO] Applyupdates doesn't work (TDataSetProvider+TClienteDataSet+TIBOQuery)
Author Helen Borrie
At 08:15 AM 27/12/2006, you wrote:
>--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> >
> > At 09:55 AM 23/12/2006, you wrote:
> > >Hi, Iam developing a 3-tier app. Although I'm new in this
>tecnology,
> > >i.ve
> > >developed several client/server apps.
> > >
> > >This is the scenario: in the middle-tier I 've a DataSetProvider
>linked
> > >to
> > >an IBOQuery and in the client side I 've TClientDataSet linked to
>de
> > >DataSEtProvider.
> > >
> > >The problems is that when I fire ClientDataSet1.ApplyUpdates(-1),
>it
> > >doesntupdate my interbase table.
> > >
> > >I've tried using a TTable conected to a Paradox Table and it works
>well.
> > >
> > >What could be happening?
> > >some especial property i shoud set in TIBOQuery, TDatasetProvider
>or
> > >TClientDataSet???

OK, we've eliminated the possibility that your TIBOQuery is non-updatable...

Next question, do you have the provider's ResolveToDataset property
set to true?

If not, it needs to be.

Then, don't forget to commit the dataset's transaction in the
Provider's AfterApplyUpdates event!

with MyProvider.Dataset.IB_Transaction do
if TransactionIsActive then
try
Commit
except
...
end;

Helen