finding parent records without any children.

Robert Lyden

Delphi Developer

Sun, 16 May 1999 03:00:00 GMT

finding parent records without any children.

I'm having a problem with Delphi 1.0 SQL. I'm trying to join 2 tables and
find all of the records in the parent table that do not have child records.
I tried to use a subquery to count the number of child records and use
that to select the ones where the count was zero, but I get an error
message from the database engine that says it does not support that
capability. I found a query example in Paradox, and got the query results
I wanted, but when I hit the SQL button, it said the SQL was not available
for this query. How can I do this?

Thanks in advance for any help.

--
Bob Lyden
bob_ly...@centuryinter.net

Dave Krajc

Delphi Developer

Mon, 17 May 1999 03:00:00 GMT

Re:finding parent records without any children.

I believe I read somewhere that you will need to use a real Client-server
database to do this. Paradox won't support it easily.

-Dave

In article <01bbdc14$6ea6c360$16b941ce@robertly>,
bob_ly...@centuryinter.net says...

Quote

>I'm having a problem with Delphi 1.0 SQL. I'm trying to join 2 tables
and
>find all of the records in the parent table that do not have child
records.
> I tried to use a subquery to count the number of child records and use
>that to select the ones where the count was zero, but I get an error
>message from the database engine that says it does not support that
>capability. I found a query example in Paradox, and got the query
results
>I wanted, but when I hit the SQL button, it said the SQL was not
available
>for this query. How can I do this?

>Thanks in advance for any help.

>--
>Bob Lyden
>bob_ly...@centuryinter.net

--
Dave Krajcar, Alternative Solutions
rai...@pacifier.com

Other Threads

1. Searching on Child Table to find Parent

2. Pascal syntax: Accessing the same record of a table on both parent and child forms

3. Parent-Child with a unique child identifier

4. MDI child, notification of parent's form main menu , when child form is closing

5. Finding Duplicate Child Records

6. exec child from parent prog.

7. 2 diff forms-PARENT & Child

8. Using TTreeView with DB for parent/child relationship

9. help needed. in parent/child relationship , thanx

10. Data integrity for relational databases (parent/child relationships)