Master/Detail

[dananiev]

Hi,

I have question about master/detail parameters. I have master INTERVALS table with FROMDATE and TODATE fields, and I have DETAIL1 detail table with DATE1 field. In native Borland TQuery I used:
"SELECT * FROM DETAIL1 WHERE DATE1>=:FROMDATE AND DATE2=:FROMDATE AND DATE2

 

[Marco Kalter]

The actual requirement here is that the detail fields must have the same name as the variables. Therefore a more logical solution would be:

where date1 >= :date1 and date2