![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Fri, Jul 4 2008 3:27 AM | Permanent Link |
Dieter Nagy | Hello,
there is a table with a generated field called "Runde" 1 2 3 4 6 <==== 7 .... there is after delete a whole. I tried ALTER TABLE zahlen DROP COLUMN runde, ADD COLUMN runde INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) that works perfect but I got ... 7 6 5 4 3 2 1 what do I wrong.... TIA Dieter |
Sat, Jul 5 2008 3:05 PM | Permanent Link |
Fernando Dias ![]() | Dieter,
Why do you think something is wrong? I can see nothing wrong here. The value "5" is back again because the column "runde" was dropped and when the column was re-added the values were generated again starting with 0 with an increment of 1. -- Fernando Dias [Team Elevate] |
Sun, Jul 6 2008 1:47 AM | Permanent Link |
Dieter Nagy | Fernando, the value is OK, but the order not. The original was from 1 to... and the new is from .... to 1. Thanks Dieter Fernando Dias <fernandodias.removthis@easygate.com.pt> wrote: Dieter, Why do you think something is wrong? I can see nothing wrong here. The value "5" is back again because the column "runde" was dropped and when the column was re-added the values were generated again starting with 0 with an increment of 1. -- Fernando Dias [Team Elevate] |
Sun, Jul 6 2008 4:54 AM | Permanent Link |
"Uli Becker" | Dieter,
have a look on the primary index of the table zahlen. It looks as if the new column runde is ordered by using this primary index. Uli |
Sun, Jul 6 2008 8:17 AM | Permanent Link |
Dieter Nagy | uli, no the primary index is on "Datum"........ TIA Dieter "Uli Becker" <test@test.com> wrote: Dieter, have a look on the primary index of the table zahlen. It looks as if the new column runde is ordered by using this primary index. Uli |
Sun, Jul 6 2008 9:33 AM | Permanent Link |
"Uli Becker" | Dieter,
hard to help with no more informations about the table and the indexes. Can you upload the table to the binaries? Uli |
Sun, Jul 6 2008 10:24 AM | Permanent Link |
Dieter Nagy | Uli,
thanks. I have altered the table. I will try it later. Many thanks for your help! Dieter "Uli Becker" <test@test.com> wrote: Dieter, hard to help with no more informations about the table and the indexes. Can you upload the table to the binaries? Uli |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |