Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing Field in Combo ListBox
Message
From
10/03/1999 16:51:46
Eric Barger
Fibeax Constructors, Inc
Findlay, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Missing Field in Combo ListBox
Miscellaneous
Thread ID:
00196100
Message ID:
00196100
Views:
56
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.
Next
Reply
Map
View

Click here to load this message in the networking platform