Number Sequence ax 2009

Hi everyone.İ have a question.İ have a number sequence like AN-#########.İf i delete a record like AN-000000005,i created a record again it give me AN-000000006.But i want AN-000000005 again.Look at this;

FolderNo

AN-000000001

AN-000000002

Step1- İ delete AN-000000002 record.

Step2- i create a new record.

Step3-

FolderNo

AN-000000001

AN-000000003 :frowning:

i want AN-000000002 record again because i deleted the record.My code like this.

NumberSeqFormHandler numberSeqFormHandler()

{

if (!numberSeqFormHandler)

numberSeqFormHandler = NumberSeqFormHandler::newForm(AlbNumberSequences::numRefFolderNum().NumberSequence,

element,

AlbArcivePlanTable_ds,

fieldnum(AlbArcivePlanTable, FolderNo));

return numberSeqFormHandler;

}


public void create(boolean _append = false)

{

element.numberSeqFormHandler().formMethodDataSourceCreatePre();

super(_append);

element.numberSeqFormHandler().formMethodDataSourceCreate();

}


public void write()

{

super();

element.numberSeqFormHandler().formMethodDataSourceWrite();

}


public void delete()

{

element.numberSeqFormHandler().formMethodDataSourceDelete();

super();

}


public void linkActive()

{

;

super();

element.numberSeqFormHandler().formMethodDataSourceLinkActive();

}


please help me .

Number sequence are very delicated. Be carefull with the changes.

What i would suggest you is to mark the sequence as Continues and insert a new field to identify the new functionality. Is the new field is marked, each time you delete a sequence, it should be inserted in the NumberSequenceList table.