--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 09:56 PM 5/11/2003 +0000, you wrote:
>
> >Sorry I wrote KeyFields but I meant KeyLinks. So what you are

saying

> >that I have done it right in KeyLinks then, but why does the lines
> >disappears after Post and then reappears when you do a Next /
> >Previous ?
>
> Some more questions --
> Are you calling Insert or Append?

I'm using a DBGrid so I don't know what it uses.

> Where do the PK values for your new rows come from? Does the user

enter

> them, or are they generated/calculated on the server?
>

Two values come from OnNewRecord on the detail(TIBOTable) and the
last one is a generator. The generator is listed in the GenatorLinks
in the TIBODatabase.

> >I didnt start to fiddle with KeyLinks until after I got this
> >problem. I know there isnt any fault in the buildup of the
> >database/PK because the same config works in BDE/Paradox.
>
> Forget what worked in Paradox. This is Firebird and it's
> client/server. Here we have transactions, which isolate your

client's view

> of database state totally at all points up to Post. The client

has *no

> knowledge* of what happens on the server.
>
> So let's get more info about those key segments. I have a

horrible feeling

> that you are still using Paradox keys to implement master/detail...
>
> Helen

Well I havent work much with Firebird but I have with ADO/MS SQL
server and same work fine there too. The client has no knowledge of
the server side I understand but wouldn't that be with exception
when the client made the change itself ?

Peter