Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox - using a SQL stored procedure as row source
Message
 
To
26/01/2000 13:33:18
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00322976
Message ID:
00323007
Views:
24
>Thanks for the suggestion. What/where is the ASSIGN event?

When yo add the property MyProperty in VFP 6 you can check the checkboxes to have MyProperty_Access and MyProperty_Assign methods which will fire accordingly each time the property is accessed (it's value is read) or changed.
In this case you may probably use RowSourceType - 2 Alias (provided it already exists) and rerun your SP only when necessary (something changes). You will still need to REQUERY the combo.

>I just tried putting the sp in the rowsource property and that seems to work. So, if I need to call it at any other time, then a REQUERY of the combo should work, right?

Yes, that's right. In this case it will both re-execute the query and repopulate the list.

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform