AUTO INCREMENT PROBLEM

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
arkagwa
Posts: 119
Joined: November 18th, 2014, 5:25 am

AUTO INCREMENT PROBLEM

Post by arkagwa »

Dear ALL

I have set my ID as an auto-increment variable. During data entry i reached a point i stopped say at 1000 (may be questionnaire have some errors). I then jumped to start at 1500 and the CAPI worked fine with auto-increment. But when i return to 1001, auto-increment remembers the highest number entered. I have tried to restart the CAPI but still does not work. What can i do for auto-increment to work for this rage of 1001 to 1449????
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: AUTO INCREMENT PROBLEM

Post by josh »

Auto increment always uses the highest value in the entire data file plus one. It does not fill in gaps. You would need to delete the cases above 1000 to get the next auto increment value to be 1001. You could make a copy of the data file, delete the cases above 1000 in the original file and continue data entry in that file. Then in the copy of the original file, delete the cases below 1001. When you are done with data entry you could then concatenate the two files together.

Another option is turn off auto-increment and enter the values manually.
Post Reply