It is probably doing a Refresh. What is the CommitAction property set to?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Dion Oliphant" <dion@...>
To: <ibobjects@yahoogroups.com>
Sent: Wednesday, November 06, 2002 12:11 AM
Subject: [IBO] raKeepDataPos


> Hi,
>
> IBO v 4.2E
> win 2000 pro
>
> I update a joined dataset using sp's, one for editing and one for
inserting.
> These sp's are called from the TIB_Query's EditSQL and UpdateSQL
properties.
> This joined dataset is the dataset for a TIB_Grid, in which the editing
and
> inserting are done. This query is the detail dataset in a master detail
> relationship. The relationship seems to be setup correctly. I can
> edit(insert) on all of the fields. I have an AfterPost event on the detail
> dataset which commits the transaction.
>
> Why would a commit on the detail dataset cause the master to do a refresh?
> If I don't set the Masters RefreshAction property to raKeepDataPos, I lose
> the insert on the Detail dataset. Is that normal behaviour, or have I
caused
> it?
>
> Thanks,
> Dion.