|Subject||Re: [firebird-support] New auto-increment column, existing data|
34 Dr Ross Avenue
Rose Hill 72102
Mobile Tel: +230 5 719 30 30
On Tue, Nov 15, 2016 at 11:58 PM, 'Some One' anotherpersonsomewhere@... [firebird-support] <email@example.com> wrote:
I am trying to add new auto-increment primary keys for existing table.
This is what I have:
set term ~ ;
declare dbkey char(8);
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?