Subject Re: [IBO] About post, commit, delete
Author Helen Borrie
At 01:43 AM 22/09/2003 +0200, you wrote:
>Was playing for a while with BufferSynchroFlags:
>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?

The dataset is designed to work on one row - the current row. All of the
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:
> >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.

Helen