Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excluding Parents without children
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00176004
Message ID:
00176011
Views:
39
>I have two listboxes with RowSourceType set to SQL. The first listbox shows available parents while the second shows the children of the selected parent that are associated with the local station. I want to modify the SQL statement of the first box so it does not show items that don't have children. Here are the SQL statements:
>
>First ListBox:
>SELECT taskID,task ;
> FROM tasks ;
> ORDER BY task ;
> WHERE (active = .T.)
> INTO CURSOR curTasks
>
>Second ListBox:
>SELECT subID, subTask, taskID ;
> FROM subTasks ;
> ORDER BY subTask ;
> WHERE ( taskID = curTasks.taskID .AND. ;
> active = .T. .AND. ;
> labName = Thisform.labName ) ;
> INTO CURSOR curSubTasks
>
>This works except that the first listbox will show items that don't have any children. How do I exclude these? Thanks.
>
>Mon

Add to the first SQL (parent) the following AND condition to the where clause

AND taskid IN ( select distinct taskid from SubTask )
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform