My company has been experimenting with your JDBC DBF drivers; they seem to work quite well. But we are having a problem with the correct syntax for a left join operation.
The following query works correctly
SELECT I.FACID, I.REFNUM, I.PATNAME, I.DETAIL1, I.LOGAS, I.REPORTER, R.REPNAME, R.RADDRESS, R.RCITY
FROM INCIDENT AS I JOIN REPORTER AS R ON I.REPORTER = R.REPORTER
But, in some cases, rows from te INCIDENT table are omittted because there is
no matching row in the REPORTER table. If we change the query to read as follows:
SELECT I.FACID, I.REFNUM, I.PATNAME, I.DETAIL1, I.LOGAS, I.REPORTER, R.REPNAME, R.RADDRESS, R.RCITY
FROM INCIDENT AS I LEFT JOIN REPORTER AS R ON I.REPORTER = R.REPORTER
We get an empty ResultSet, even though we know that there are matching rows.
Is there a problem with the syntax we are using?
|
|
Your sql is correct. Failed to recur your issue. Please send us your dbf samples. BYW, if your INCIDENT contains only deleted rows, you will get an empty ResultSet.
|
Thanks for your answer. Unfortunately, the tables involved are much too
large and contain confidential information. We will recheck the INCIDENT table for
deleted rows.
Ralph Mace
|
You can try deletesAreVisible=true connection property.
BTW, the quickest way is to use
SELECT I.FACID, I.REFNUM, I.PATNAME, I.DETAIL1, I.LOGAS, I.REPORTER FROM INCIDENT
AS I
to see wheteher HXTT DBF can see those rows.
|
Main
webmaster@hxtt.com