How to populate a Combo Box from a cursor

[Jomercat]

Hi,

I believe I placed this message in the wrong group.

Here it is again.

I am new to VFP and Ineed to poulate a combo box from a cursor; for example.

Select * from tablename into cursor temp.

I want the results of the temp cursor to populate the combo box.

Any help would be appreciated.

Jose.

 

[DSummZZZ]

Just set the RowSourceType property of the combobox to 2-Alias, then set the RowSource property to the name of your cursor.
Make sure you have the cursor available before the combobox gets instantiated though. In other words, the cursor has to be created programmatically prior to running the form, or in the form's Load event.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Jomercat]

DSummZZZ,

Thanks so much!!!!

It worked.

Jose.

 

[teresas]

Jose,

You can also set the RowSource property to the SQL statement itself (Select * from tablename into cursor temp) with the RowSourceType property to 3-SQL Statement.

Teresa

 

[Jomercat]

Teresas,

Thanks for the reply!!!

Jose.

 

[Mike Lewis]

Just one other point to add to the good advice you've already been given: Set the combo box's ColumnCount property to the number of fields from the cursor that you want to display.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[Jomercat]

Thanks all of you who replied!!!!

I appreciate your help.

MikeLewis- Will it work the same if I just use the RowSource like this?

.RowSource ='Cursor.field'

Thanks.

Jose.

 

[Mike Lewis]

Hi Jose,

Yes, that will work, but you will have to set the RowsourceType to 6 rather than 2.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)