Subject | Re: [IBO] About post, commit, delete |
---|---|
Author | Helen Borrie |
Post date | 2003-09-21T23:41:33Z |
At 01:43 AM 22/09/2003 +0200, you wrote:
DML methods are expected to apply to the current row. BufferSynchroFlags
flags one row. Keylinks identifies THAT row. So all of these one-row
things need to know how to identify THAT row. With your setup
BufferSynchro can't find that row because it can't make a WHERE clause that
will find it exactly on the server. You get the error because you don't
have keylinks.
read this again:
>Was playing for a while with BufferSynchroFlags:The dataset is designed to work on one row - the current row. All of the
>if I set autocommit & bsAfterInsert, Post after insert gives an error -
>"Multiple rows in singleton fetch, check keylinks} & etc....
>If I disable bsAfterInsert, then there is no any error. In both cases
>KeyLinks are the same & point PK
>What is wrong with tye set bsAfterInsert?
DML methods are expected to apply to the current row. BufferSynchroFlags
flags one row. Keylinks identifies THAT row. So all of these one-row
things need to know how to identify THAT row. With your setup
BufferSynchro can't find that row because it can't make a WHERE clause that
will find it exactly on the server. You get the error because you don't
have keylinks.
read this again:
>At 2003.09.21 19:18, you wrote:Helen
> >If you set BufferSynchroFlags to include bsAfterInsert, then IBO should
> >take care of bringing the inserted row into the buffer. But it won't work
> >if your keylinks are wrong, or if IBO doesn't know the new PK of the
> >row. In that case a Refresh will be needed to make the new row visible.