I'm trying to evaluate your product but have come across a problem. when I execute the following SQL command against a Visual Foxpro DBF
select b_car, b_forwhat, b_cleardt
from fstckh
WHERE b_forwhat = 'D'
and deleted()=false
AND b_cleardt = '2019-10-02';
I get the following output, please note the b_cleardt column does not match the where clause:
C00926,D,1992-10-26
C00923,D,1992-10-23
C00907,D,1992-12-05
C00906,D,1993-01-22
C00897,D,1992-10-26
C00780,D,1992-10-15
C00736,D,1993-01-15
C00677,D,1992-07-15
C00464,D,1992-08-11
C00200,D,1993-10-01
When I execute the same SQL in a PostgresSQL version of the data I get the following correct results, please note the differing number of records:
b_car | b_forwhat | b_cleardt
--------+-----------+------------
C04762 | D | 2019-10-02
C04810 | D | 2019-10-02
C04843 | D | 2019-10-02
C04937 | D | 2019-10-02
C04941 | D | 2019-10-02
C04942 | D | 2019-10-02
C04953 | D | 2019-10-02
C04956 | D | 2019-10-02
Could you advise me how to proceed please.
I am using DBF_JDBC43.jar
David McCallum
|
It seems that you should have an obsoleted index information on b_cleardt.
First, backup your database files.
Then, run once "reindex all on fstckh;"
to see whether your issue disappear.
If you met issue still, please email us your database samples, since we met some FoxPro format variables from German.
|
Unfortunately I cannot supply data due to it contailining personal information.
All the data is in UK English
The problem is still there after the re-index
David
|
Try to download the latest package to see whether your issue disappear.
|
I am currently using DBF_JDBC43.jar, which is the latest version I can download.
I see there is a version 7.1, but the evaluation link for that is disabled on your web page.
Is there a way to download this veriosn?
David.
|
|
The latest version is v7.1.084 released on yesterday, and you can login to download the latest DBF_JDBC43.jar, which is a subversion for JDK11.
|
|
I have sent an email to support with a table that demonstrates the problem.
|
|
Supported. Please redownload it.
|
Main
webmaster@hxtt.com