number is required 1

[taree]

can someone help me here.I am getting number is required error message.thank you

stringvar mp;
if not isnull({U_PERMIT.MILE_PT_BEG}) then
mp = {U_PERMIT.MILE_PT_BEG}
else
mp ='0000000000';

select uppercase({?sortfield})
case 'SUBAREA' : {DISTRICT_SUBAREA.CODE}
case 'CONTROLSECTION' : {U_PERMIT_SEGMENT.CONTROL_SECTION}
case 'BEGREFPOINT' : {U_PERMIT.MILE_PT_BEG}
case 'TRUNKHIGHWAY' : {U_PERMIT_SEGMENT.TRUNK_HIGHWAY}
case 'PERMITNUMBER' : {U_PERMIT.PERMIT_NUMBER}
default: {U_PERMIT_SEGMENT.TRUNK_HIGHWAY}+mp+{U_PERMIT_SEGMENT.CONTROL_SECTION}

 

[lbass]

In the first part of your formula, you should be using:

stringvar mp;
if not isnull({U_PERMIT.MILE_PT_BEG}) then
mp [red]:[/red]= {U_PERMIT.MILE_PT_BEG}
else
mp [red]:[/red]= '0000000000';

Can't tell which part of the formula needs to be fixed, but the formula results must all be strings, so if some of them are numbers, you should wrap them like this:

totext({table.field},0,"")

-LB

 

[taree]

that was the cas.thank you lbass.