Hi Legolas, If you define your identity column as "generated by default" then it will automatically increment the identity column - unless you specifically supply a value for that column. You may have to be careful about what happens when you insert rows if you insert a row with eg. ID=5 and the autoincrement value is less than that. One solution would be to reserve space e.g. the lowest 10 values for your custom records by specifying the start/increment values for the identity column.
regards Tony Seebregts Legolas Woodland wrote: > Hi > Thank you for reading my post. > I have a table with one identity column , so Derby will generate a > value for this column in evry insert. > what should i do if i need to make some record with customized ID ? > for example i want my admin user to have id=1 ? how i should insert it ? > > Thank you > >
