Microsoft KB Archive/131121

= Combo Box with RowSourceType of SQL Must Result in Cursor =

Article ID: 131121

Article Last Modified on 2/15/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q131121



SUMMARY
If the RowSourceType property of a combo box is set to SQL-Statement, the actual SQL statement in the RowSource property must result in a cursor, not an array. For example, if the RowSourceType property of a combo box is SQL-Statement, and the RowSource property contains this command: SELECT DISTINCT REGION FROM CUSTOMER INTO CURSOR TEMP the unique regions from the customer table are displayed in the combo box and a cursor named TEMP is created

If the SELECT statement creates an array instead of a cursor, the combo box displays data from the first field of the currently selected table. If no table is currently selected, a syntax error displays.

Additional query words: VFoxWin

Keywords: KB131121

-

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

© Microsoft Corporation. All rights reserved.