Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Missing Field in Combo ListBox
Message
De
10/03/1999 16:51:46
Eric Barger
Fibeax Constructors, Inc
Findlay, Ohio, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Missing Field in Combo ListBox
Divers
Thread ID:
00196100
Message ID:
00196100
Vues:
62
Okay, here's a fun one for you guys and gals. While trying to create a data entry form for employees' time, I ran into a gliche that is frustrating to say the least. On this form, there is a dropdown listbox that displays pre-sorted tasks for various departments. The data is sorted through the following SQL statement:

**gcDept is a variable selected from a dropdown combo on the same form

SET SAFETY OFF
SELECT Str_task.code_num, Str_task.descriptio;
FROM fdms!str_task;
WHERE gcDept = Str_task.dept;
ORDER BY Str_task.code_num;
INTO TABLE H:\VFP\FDMS\DATA\DATAQUERY\QWhodaddy.dbf
SET SAFETY ON

The resulting data in the dropdown listbox contains only the tasks that apply to the department that was entered earlier (gcDept). However, only the first (str_task.code_num) is displayed; the second (str_task.descriptio) is not visible even though the combo builder shows otherwise. Also, to add further entertainment, if we select the department three times then the str_task.descriptio finally appears. I say whassup wit 'dat? Any help or comments would be appreciated. I've spent the day on it and my head is fried. Thanks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform