Hi Joe,
Those settings are working for me in my quick test. Does the SQL statement you have in the RowSource work in code?
As a test I built a cursor with the days of the week in it in the Load event of a form. CREATE CURSOR ComboBoxData (id i, displaytext c(30)) I set the ComboBox.RowSource to select displaytext from comboboxdata into cursor t1 and set the ComboBox.RowSourceType = 3 && SQL statement
To be consistent with your select statement I added the "distinct" clause and it still works.
I tested in VFP 9 SP2 Hotfix 3
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe Yoder Sent: Saturday, May 22, 2021 3:04 PM To: profoxtech@leafe.com Subject: Form designer rules?
I want to use an sql select statement as the row source for a combo box..
- When I set the row source type to 3-SQL and enter the row source as "select space distinct from map into cursor T1" attempting to run the form results in "Program error Unrecognized command verb" - If I set the row source type to 2-Alias and the row source to T1 and put the SQL select statement into the init method of the control the Combo box populates properly.
I would have expected that the system would be smart enough to run the SQl statement before trying to use it's output. Is there something else I need to call perhaps in the form init method?
Thanks in advance,
Joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]