Hi,
I am using Access_JDBC30-0.5 jar and facing a problem while selecting records from a query view. The views that our clients use have (!) as a separator between tablename and column name.
While executing a simple select query it fails with the error
java.sql.SQLException: Lexical error: !ACRT,'US7')>0,Mid(tbl_Brand_In_Use!ACRT,InStr(1,tbl_Brand_In_Use!ACRT,'US7'),6),'') AS TerritoryFormula,tbl_Brand_In_Use.* FROM tbl_Brand_In_Use;
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.c7.for(Unknown Source)
at com.hxtt.sql.eg.new(Unknown Source)
at com.hxtt.a.b.g(Unknown Source)
at com.hxtt.sql.bq.o(Unknown Source)
at com.hxtt.sql.ah.if(Unknown Source)
at com.hxtt.sql.dk.(Unknown Source)
at com.hxtt.sql.em.(Unknown Source)
at com.hxtt.sql.bq.prepareCall(Unknown Source)
at com.hxtt.sql.bq.prepareCall(Unknown Source)
at com.hxtt.sql.bq.prepareCall(Unknown Source)
at com.hxtt.sql.b8.(Unknown Source)
at com.hxtt.sql.access.aw.do(Unknown Source)
Please confirm whether this is an issue with the version that I am using, if yes then whether there is a fix available for this or there is something that I am missing in the code.
My Query view looks like:
SELECT IIf(InStr(1,tbl_Brand_In_Use!ACRT,"US7")>0,Mid(tbl_Brand_In_Use!ACRT,InStr(1,tbl_Brand_In_Use!ACRT,"US7"),6),"") AS TerritoryFormula, tbl_Brand_In_Use.*
FROM tbl_Brand_In_Use;
Thanks in advance,
Ankita
|
Because MS Access is not using the standard sql. You can use directly tbl_Brand_In_Use.ACRT or ACRT to replace tbl_Brand_In_Use!ACRT in MS View.
|
Is there a way to do it thorugh code before actually reading from the query view, as MS Views are created by our clients, and they insist on using (!), also they have a lot of MS Access files and I am not sure how much effort is required to change all query views for them. We would really like to continue using this driver.
|
Supported. Please download the latest package.
|