Microsoft KB Archive/134466

= How to display multiple columns of the SQL-SELECT cursor in a combobox object in Visual FoxPro =

Article ID: 134466

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Visual FoxPro 7.0 Professional Edition
 * Microsoft Visual FoxPro 8.0 Professional Edition
 * Microsoft Visual FoxPro 9.0 Professional Edition

-



This article was previously published under Q134466



SUMMARY
This article describes how to populate a combobox object with multiple columns. This is done from a cursor that is created by using a SELECT-SQL statement.



MORE INFORMATION
For a DropDown ComboBox to display an initial value and multiple columns from a cursor created by an SELECT-SQL statement, Microsoft recommends that you use the following property values and methods:

Example ComboBox Properties: BoundColumn  = 1 ColumnCount  = 3 ColumnWidths = 0,100,100 RowSource    = SELECT city+' '+region as MyField,city,region ; FROM Customer ; where !empty(region) ; into cursor MyCursor

RowSourceType = 3 Example: ComboBox GotFocus event This.Value = MyCursor.MyField

Additional query words: VFoxWin

Keywords: KB134466

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.