ado query using a date field

Thanks found the answer on web problem solved.
Tony
--- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, "tony_bat" <tony_bat...> wrote:
&gt;
> My sql staement looks like this - select mess_id, tape_num, title
from
> messtbl m, spkr s where s.spkr_id = m.spkr_id and m.dte
= '9/18/2002' -
> spkr_id is a numerical field in both tables and dte is a date field
in
> messtbl.
>
> get error message - data type mismatch in criteria expression.
>
> any suggestions on what is wrong with statement.
> D7 Prof XP SP2
> Tony
>

Messages in this topic (2) Reply (via web post) | Start a new topic

.