Querying a Paradox Database with ADO
Posted on 2003-11-03
I have connected sucessfully to a Paradox Database using both a System DSN and a Microsoft Access linked table setup.
I am trying to query table ACTIVITY, with a criteria for a specific date. The query is quite simple;
WHERE ACTV_BEGIN_DATE = #27-Aug-2003#
The table has records dating from the 26/08/2003 and onwards. The query returns rows where ACTV_BEGIN_DATE is equal to the 26th or the 27th. If I then change the query to;
WHERE ACTV_BEGIN_DATE = #28-Aug-2003#
It then returns rows for the 26th, 27th, and 28th. This occurs regardless of the access method.
I have simplified the query slightly to try and illustrate my problem. The final query will be specific regarding selection of fields, and will use a similar WHERE clause to the one below;
WHERE ACTV_BEGIN_DATE BETWEEN #1-Aug-2003# AND #31-Aug-2003#