If I execute this query in VS2008, data is returned OK:
SELECT DESCRIPTION
FROM AZTECA.REQUEST
WHERE (DATETIMEINIT > TO_DATE('09/03/2008', 'MM/DD/YYYY')) AND (DATETIMECLOSED < TO_DATE('09/04/2008', 'MM/DD/YYYY'))
If I execute the same query with a parameter:
SELECT DESCRIPTION
FROM AZTECA.REQUEST
WHERE (DATETIMEINIT > TO_DATE('09/03/2008', 'MM/DD/YYYY')) AND (DATETIMECLOSED < TO_DATE(:CLOSEDDATE, 'MM/DD/YYYY'))
and enter 09/04/2008 as the date, I get this error:
ORA-01858: a non-numeric character was found where a numeric was expected
Has anyone seen this one before?
Thanks in advance,
Mapper