Как восстановить целостность автоинкрементного поля?

Материал из DRKB

Как восстановить целостность автоинкрементного поля?[править | править код]

Problem/Question/Abstract:

Recently I got unique key violations during insert attempts on a piece of code that used to work (what can go bad, will go bad). I found that the offending field - was actually created by a generator. For some reason the generator returned values that where already in the database.

  • how can I display the current value of the generator?
  • how can I adjust the value of the generator?


Answer:

See the example (table name is SD_LOAD, generator name is GEN_SD_LOAD).

Note
You cannot modify the value of the generator inside of a trigger or stored procedure. You only can call the gen_id() function to increment the value in a generator. The SET GENERATOR command will only work outside of a stored procedure or trigger.


SELECT DISTINCT(GEN_ID(gen_sd_load, 0))FROM sd_load
set GENERATOR gen_sd_load to 2021819


Language: en
Source: Взято с Delphi Knowledge Base: http://www.baltsoft.com/
ID: 02907