Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

purge autoPk sequence

Avatar

Avatar
Validate 1
Level 1
jyotiyadav3
Level 1

Likes

4 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
jyotiyadav3
Level 1

Likes

4 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
jyotiyadav3
Level 1

26-07-2016

Hi,

I have a schema whose primary key has:

<element autopk="true" label="Companies" labelSingular="Company" name="company"

           pkSequence="XtkNewId" sqltable="MotCompany">

Now it gives error when you try to insert new data in this schema. It says:

988664_pastedImage_1.png

The solution which I am able to find is: either purge the data or start negative sequencing. But I am not able to get how to do it. Also, does purging sequence will cause any loss of existing data?

Thanks,

Jyoti

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Level 2
John_T_Smith
Level 2

Likes

5 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 5
Level 2
John_T_Smith
Level 2

Likes

5 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
John_T_Smith
Level 2

26-07-2016

The Forum Lounge is not for technical help, please provide the name of the program you are using so your message may be moved to the correct program forum