How to to change the case id value to any value (higher or lower)
The spec CHANGENEXTID.SPX is a setup that allows you to change the case id value to any value (higher or lower). The software will not otherwise let you set the case id lower.
You MUST also re-make the quota file for this to work if you are running under the server. This means re-compiling your questionnaire, then using the IN/OUT options to unload you current quotas and load them into the new quota file. Then copy the new quota file to the quota directory.
>DEFINE @study test ''set to study name>DEFINE @newid 5 ''set to value for new id>DEFINE @TEST ''to see it work using test files>filldefinesinquotes>ifdefine @TEST~cln file @study create next_id=9995new~in;>endif~cln file @study~2 create next_id=@NEWIDnew~in~in files="@study~2.tr,@study~.tr"~out @study~3 writenow ~cln file @study~3n firstdelete~in @study~3>status in~in;>IFDEFINE @test>copy @study~3^tr @study~^tr>delete @study~3^tr>ENDIF>delete @study~2^tr