javadictionary auto increment

[Former Member]

javadictionary

after i create a java dictionary project and add a table

i have defined several columns

tableid, uiname, cvalue

how do i make tableid as autoincrement field start with 1000001

the next record + 1 become 1000002

i am using MSSQL .

pls advice

[Former Member]

Hi,

Im in a similar situation as i need to set the index attribute (primary key) to be autoincremented each time i insert data into the table. Im using Webdynpro for Java and i have created my Dictionary project.

Thank you!

[Former Member]

Hi,

If you want to make it as auto increment in MS SQL Server then here is the solution:

For the column, make the <i>Identity</i> property as TRUE

<i>Identity seed</i> as 1000001 and <i>Identity Increment</i> as 1

Is this what you are asking for?

Regards,

Vnekat