Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Populating a list box with sql
Message
From
27/05/1999 19:40:24
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
To
27/05/1999 19:35:52
Paul Wyett
Resource Link Software
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00223762
Message ID:
00223767
Views:
29
>I am trying to fill a list box with 4 columns from a cursor that is in a command click event. I can get the values to appear in the list box from the cursor using the form load event, then I change the values in the cursor with a new sql statement, but for some reason they will not appear in the list box until the 3rd time it is "clicked".
>
>I am refreshing the form each time and have also tried clearing the cursor. Why does it not show up in the list box on the first command.click? They will show up after the first command.click but only if I click inside the list box, never with just one click of the commmand button.

Try a

THISFORM.lstListbox.Requery()

after you have updated the contents.
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform