Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using views to populate list box with multiple records
Message
From
29/01/1999 14:17:04
Noman Aftab
Embry-Riddle Aeronautical University
Daytona Beach, Florida, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using views to populate list box with multiple records
Miscellaneous
Thread ID:
00181943
Message ID:
00181943
Views:
37
HI everyone!
Let me thank everyone for helping me out.
I have another question here, this time about using views. Can anyone tell me if it is better to create local views and then populate list boxes with multiple records by putting a filter on the parent record.
Here is the code which I am using in refresh procedure of the listbox:

cparentTable = Alias()
* selects the view
SELECT zoneview
* sets filter on wcdet.wcnumber<-- which is a field from parent table
SET FILTER TO ALLTRIM(wcdet.wcnumber) = ALLTRIM(zoneview.wcnumber)

* Populating list box with relevent field values
Rowsource = 'zoneview.zone'
Rowsourcetype = 6

SELECT (cparentTable)

OR, what if I put SQL SELECT Statements in the refresh() for each list box and try to retrieve this data.

Also, how should I manipulate the data in a view by using a mover lists.

Please advise me as what do I need to do from here on.
THANKS!
Next
Reply
Map
View

Click here to load this message in the networking platform