Click here to Skip to main content
15,559,642 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Updated 2-Jan-11 19:14pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900