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?