Re: sql question


>I tried modifying the where statement to the following to get record 2
>where ( hrs_emp_clocknum = :emp_clocknum ) and (
> (hrs_startdate < :startdate and hrs_enddate > :startdate) or
> (hrs_startdate > :startdate and hrs_startdate < :enddate))and
> ( pad_code = hrs_status )
>
>this added two new parameters named 'startdate' to the paramaters
>property of the adodataset. when this happened, I thought I was on the
>wrong track. Is there a way to do this?

The Borland ADO components do not allow you to use a parameter name more than
once. Just give the second set of date parameters new names and you SQL should
work.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.