Does your table have a primary key?
Are you using GeneratorLinks?
Are your triggers messing around any?

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

----- Original Message -----
From: <sassicaia70@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 28, 2001 5:34 AM
Subject: [IBO] Problem with Append in a IBOTable


> Hi
> I have a big problem with Append in a IBOTable
> I use IBO 3.6 Dg (demo) because I would like convert my application
> from DBF to IBO.
> I use IBOTable with PessimisticLock = TRUE and I have this problem:
>
> IboTable1.PessimisticLock := TRUE;
> IboTable1.Open;
> IboTable1.IndexName := 'COD';
> IboTable1.Append;
> IboTable1.FieldByName('COD').AsString := '100';
> IboTable1.Post;
> ShowMessage(IboTable1.FieldByName('COD').AsString) --> 100
> IboTable1.Refresh;
> ShowMessage(IboTable1.FieldByName('COD').AsString) --> 1
>
>
> After the Refresh the position of record (previously inserted
> therefore code 100) is on an other record. As I can resolve such
> problem. I would want that after the refresh it does not come changed
> the position of record.
>
> P.S. Problem seems to be present single if the record comes
> inserted with Append or Insert and not with the Edit.