Combo List Sorting?

[PogoWolf]

Hey all,
I'm working in VFP 3.0, and haveing an issue with sorting
data.

I have a combo box on a form, and trying to sort the list.
I've tried setting the sort properite to 'true' but FoxPro will not let me. (always goes back to False) and I've tried
adding code (thisForm.Combo2.Sort = .T.) but that doesn't seem to work either...

does anyone have any ideas? =)
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[fluteplr]

Sort only works if the row source type is set to value or you are manually adding the rows. If you are binding to a cursor, array or sql statement they must be sorted in the order you want rather than using the sort property.

 

[PogoWolf]

Well, that explains why it's not working.... =)
I think the data is bound via the cursor (I just created the combobox, clicked the 'builder' and made the connection that way)

Could you please, explain how I might be able to sort this?

Thank you!


---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[fluteplr]

if you are using the foxpro tables the easiest way IMHO is to set the rowsourcetype to sql statement, and in the rowsource put a sql statement like the following

select code from mytable order by code into cursor curcodes

you need the into cursor part to prevent the select statement from opening a browse window (the default)

if you are using views I usually select the rowsourcetype of alias and then create a view the selects the fields I need in the correct order.

 

[PogoWolf]

I'm useing Tables, so the SQL will most likly work the best. =) Thank you!!! ---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[Tfrymire]

You most likely have the combo box rowsource property set to an array, table or other source.(rowsourcetype is related too). If this is the case, you can't set the sorted property.. Hope this was of help

 

[PogoWolf]

I ended up making a 'view' and sorting that. =) ---===///The PogoWolf\\\===---
Amateurs built the ark, Professionals built the Titanic.

http://www.pogowolf.com

http://www.4TheGames.net