Is it true that the BDE version 5.01 solve this problem ?
Freddy Biets
h...@village.uunet.be
Guy Goossens heeft geschreven in bericht <7g9kfj$o5...@forums.borland.com>...
Guy Goossens <guy.go...@bjl.be> wrote in message
news:7g9kfj$o5...@forums.borland.com...
I assume that you have created persistent TFields. When I've had this error
in the past, I've cured the problem by setting the autoinc field to read
only.
Mike Orriss (TeamB)
(No e-mail replies, please, unless explicitly requested!)
Guy Goossens <guy.go...@bjl.be> wrote in message
news:7g9kfj$o5...@forums.borland.com...
> I have some tables with the primary key set to an autoincrement field. I
Autoincrement keys are not as robust as normal fields. The last increment value
used is stored in the table header. If there is any error on updating the table
the next value stored in the table header might not get updated. The result
will be that the value is reused on the next insert and a key violation.
--
Brian Bushay (TeamB)
Bbu...@NMPLS.com
Hello,
Yes it is multi-user, i meen the paradox database is installed on NT server
in a shared directory and multiples computers are connected to this
directory and they access the database over the network.
What do you meen by "something else" ? Do you meen i must generated the
numbers by code ? If so how can i do if i want the user be able to add
record in a DBGrid ? I feel this give me a lot of work, i have multiples
tables using autoinc. field :-(
Thanks for your attention.
Hello,
What's "persistent TFields" ? Do you meen : setting the ReadOnly property
for the field in Delphi ?
I dit'n do this, it's too easy, i will try this.
Thanks for your attention.
--
Olivier Dahan
oda...@cybercable.fr
Delphi 32b C/S certified engineer
Biets Freddy <h...@village.uunet.be> a écrit dans le message :
7g9rhv$o6...@forums.borland.com...
> if this is multi-user than you have to search for something else than
> auto-incremental keys.
> They do not work properly in a multi-user environment.
>
> Freddy Biets
> h...@village.uunet.be
>
>
> Guy Goossens heeft geschreven in bericht
<7g9kfj$o5...@forums.borland.com>...
> >I have some tables with the primary key set to an autoincrement field. I
> >get sometimes (when i append record) a "key violation" error. This error
is
> >a non-sense because autoincrement integer must be off course unique. Pack
> >the table solve the problem. Someone say : this is a bug in BDE <=4.51
and
> >i think that's true.
> >
Yes