I am trying to add new auto-increment primary keys for existing table.
This is what I have:
==
set term ~ ;
execute block
as
declare dbkey char(8);
begin
for
select rdb$db_key
from mytable
into :dbkey
do
begin
...
end
end~
set term ; ~
==
This fails with error "malformed string", it looks like either rdb$db_key does
not match char(8) or maybe it is related to same character set settings. Any
suggestions?
It also seems that when new entries are added the auto-incremented values will
start from 0, causing conflicts. Is it ok to simply right click the generator
in FlameRobin, select "set value" and enter a value higher than the highest
existing or will that cause any trouble?
