Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Lexical error while reading from query views that use (!) as separator
Ankita Agarwal
2010-08-11 05:11:59.0
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.0
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.0
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.0
Supported. Please download the latest package.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap