Hi Jason,

The Master dataset's CommitAction = caRefreshKeys, the detail =
caRefreshKeys.

Thanks,
Dion.



-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, November 06, 2002 9:25 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] raKeepDataPos


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.




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/