Can you try this one?
.lstDim2.RowSource = 'Select DISTINCT IIF(dim2-INT(dim2)>0,'+;
'padr(ALLTRIM(STR(dim2,5,1)),7),padr(ALLTRIM(STR(dim2,5,1)),7)) AS dim2 FROM surface '+;
'INTO CURSOR curDim2 WHERE ALLTRIM(.lstDesc.Value)==ALLTRIM(desc) '+;
'AND .lstDim1.Value==fractionconv(dim1) ORDER BY dim2'
>I have the following code in the 'InterActiveChange' method of a listbox (.lstDim1):
>
>
>.lstDim2.RowSource = 'Select DISTINCT IIF(dim2-INT(dim2)>0,'+;
> 'ALLTRIM(STR(dim2,5,1)),ALLTRIM(STR(dim2))) AS dim2 FROM surface '+;
> 'INTO CURSOR curDim2 WHERE ALLTRIM(.lstDesc.Value)==ALLTRIM(desc) '+;
> 'AND .lstDim1.Value==fractionconv(dim1) ORDER BY dim2'
>
>
>
>This fills listbox 'lstDim2' with the correct data, but when I go to select a value the only values that will show up in the listbox are the ones that do not contain a decimal (i.e. ALLTRIM(str(dim2)) from above).
>
>Any suggestions would be greatly appreciated!
>
>Thanks in advance,
>Russell
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.