I do not believe this is working properly? Our connection string looks like this:
jdbc:dbf:/C:/dev/db/DBF?lockType=FOXPRO;caseInsensitive=true;ODBCTrimBehavior=true;emptyDecimalAsZero=true
Where a values in the ITEM field of the tblParts equal 'H2S-WD500'
SELECT * FROM tblParts
WHERE ITEM = 'h2S-WD500'
returns zero records, but if we do this it works fine:
SELECT * FROM tblParts
WHERE ITEM = UCASE(h2S-WD500)
We thought if we included "caseInsensitive=true" in our datasource string as listed above we would not need to use the UCASE function?
We are using the latest trial download.
|
|
I guess that you should have an index on ITEM, and index match is case sensitive. We will check and find a solution for it.
|
I just tried the latest version emailed and we're halfway there! It works when there is an "=" in the WHERE clause, but not when there is a "LIKE"
Works:
WHERE ITEM = 'h2S-WD500'
Does not work:
WHERE ITEM LIKE 'h2S-WD5%'
|
>WHERE ITEM LIKE 'h2S-WD5%'
You should use ILIKE
|
Main
webmaster@hxtt.com