Combobox1 selects into a cursor. Use that cursor name in the where clause of the select statement in combobox2. In the valid event of combobox1, call the requery method of combobox2. The initial queries are processed after the form load event. They only requery when told to.
HTH Tracy On May 23, 2021 11:26:11 PM EDT, Joe Yoder <j...@wheypower.com> wrote: >My data is in a table called labels with three fields, space, location, >and >label. >I thought my problems were solved but now when I setup my second combo >box >with the row source set to > >select location distinct from labels where labels.space = >thisform.combo1.value = labels.space into cursor T2 >I get the message "Thisform can only be used within a method" > >When I set the row source to > >select location distinct from labels where labels.space =combo1.value >= >labels.space into cursor T2 >I get the message "Ali8as Combo1 is not found." > >When I put the SQL code in the load or init methods of the form it >works >without error so the code is okay >Is there a different syntax needed here or do I need to handle this in >a >different way? > >Thanks, > >Joe > >On Sun, May 23, 2021 at 7:23 PM Joe Yoder <j...@wheypower.com> wrote: > >> Tracy, >> >> I did another test form using days of the week like yours. I still >got >> the error. Then I removed the quotes around the CSL statement and it >> worked! Somewhere in my surfing I had read that the quotes were >required >> but that is apparently incorrect. >> >> More details: >> >> 1. When does the SQL get executed? When it is first loaded? Each >> time the control gets focus? When requiry is called? >> 2. Are all cursors created this way in scope for the entire VFP >system? >> 3. Is there a simple way to see the VFP code generated by the Form >> Designer to understand how it works? >> >> Thanks so much, >> >> Joe >> >> On Sun, May 23, 2021 at 11:41 AM Tracy Pearson ><tr...@powerchurch.com> >> wrote: >> >>> 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/1f1ea044-67b3-4487-9573-71c08d7ba...@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.
