Master / Detail with TADOQuery

Master / Detail with TADOQuery

Post by KonZ » Sat, 14 Aug 2004 03:10:57


hi there

Im wondering if its possible to set a master / detail (relation?) using a
TADOQuery?
I've done it using plain tables but neither found how to do what I want to
do.

Thanks in advnce,

KonZa
 
 
 

Master / Detail with TADOQuery

Post by Mike Shkol » Sat, 14 Aug 2004 04:57:36

Yes, you may use Master-Detail relation for TADOQuery. Just use in the
detail SELECT the parameter in where-clause that is related to master's
unique field.
For example:
SELECT * FROM det WHERE (CustomerID = :ID)



a