foxpro table error

See more:

programming

Good day to anyone.

SET CURSOR ON
    if this.value = "C"
       	sele 37	&&&*use COLLRCPT shared
		*index on dtoc(datepaid)+orno to coldtvx2
		*index on orno     to colOrvx2
		*index on prno     to colprvx2
		*index on patno    to colpatx2
		*index on htn      to HTNclOX2
		set century on
		mn=substr(dtoc(date()),9,2)
		set order to credit		
		go bottom
		mn1 = "C" +mn+ padl(allt(str(val(substr(orno,4,4)) + 1)),4,"0")
		thisform.pageframe1.page1.text10.value = mn1	
		thisform.pageframe1.page1.text10.enabled=.f.
		thisform.pageframe1.page1.combo7.SETFOCUS   
		thisform.container1.enabled=.t.
		thisform.container1.visible=.t.
		thisform.container1.text10.enabled=.t.
		thisform.container1.text10.value=""
		thisform.container1.text10.setfocus		
    
    else

This is my code on O.R. the problem is the go bottom code. The last record on the foxpro table is C112526. So the next record must be C112527 but when it shows up it is still C112526. even when i add the the number C112527 on the table the next must C112528 but still it shows up only C112526.

Some help me please