Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Exeter, Devon, UK

    Angry Unanswered: VB Query to Paradox 5 tables


    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

  2. #2
    Join Date
    Jan 2003


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts