I have VFP tables, try to access through your JDBC drvier.
When I open query "SELECT * FROM PLU WHERE KEY = AAA", an exception is thrown.
"Can't parse index expression RIGHT(STR(dept--1000,4)3)+IIF(""=ALLTRIM(master),plu+master,master+plu)"
Does your DBF JDBC driver support the complex expression in Index file.
Thank you.
|
DBF supported complex expression. Please check your index expression file. You should use RIGHT(STR(dept-1000,4),3)+IIF(""=ALLTRIM(master),plu+master,master+plu) or RIGHT(STR(dept+1000,4),3)+IIF(""=ALLTRIM(master),plu+master,master+plu).
-- will be considered as comment mark in SQL92 standard. ...4)3) should miss a ',' token between ')' and '3'.
|
Main
webmaster@hxtt.com