Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using views to populate list box with multiple records
Message
De
29/01/1999 14:17:04
Noman Aftab
Embry-Riddle Aeronautical University
Daytona Beach, Floride, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Using views to populate list box with multiple records
Divers
Thread ID:
00181943
Message ID:
00181943
Vues:
36
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!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform