VB Query to Paradox 5 tables [Archive]

Che

12-18-01, 08:59

Hi!

I hope someone can help me out! I have a system that uses Paradox version 5 tables and I need to query them within a certain date range. When I try SELECT * FROM EMPL WHERE EMPDATE='01/01/1998' I get an error.

If I trySELECT * FROM EMPL WHERE EMPDATE=TO_DATE('01-JAN-1998','DD-MMM-YYYY') I get an Not supported error.

So my question is, has anyone managed to get VB6 to return data from a paradox table within a date period?

I am connecting with DAO 3.6.

Thanks In Advance
Che

MGC

01-24-03, 10:54

Try the following, I tried it in DAO3.6 with paradox 5 tables on paradox dateTime fields.

select * from mytable where mydate > #2002/12/01# and mydate < #2002/12/05#

Hope this helps.