Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox Value
Message
From
27/02/2004 16:42:27
 
 
To
27/02/2004 11:29:04
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00881514
Message ID:
00881688
Views:
21
>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

It's been a while, but maybe you need to issue a requery after setting the rowsource.
Previous
Reply
Map
View

Click here to load this message in the networking platform