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-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Saturday, May 22, 2021 3:04 PM
To: profoxt...@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]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/006801d74fea$04077c60$0c167520$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
