Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
Lexical error while reading from query views that use (!) as separator
Ankita Agarwal
2010-08-11 05:11:59
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
Re:Lexical error while reading from query views that use (!) as separator
HXTT Support
2010-08-11 05:22:05
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.
Re:Re:Lexical error while reading from query views that use (!) as separator
Ankita Agarwal
2010-08-11 23:37:04
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.
Re:Re:Re:Lexical error while reading from query views that use (!) as separator
HXTT Support
2010-08-12 07:12:14
Supported. Please download the latest package.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap