Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 DBF
HXTT DBF from field
Ken Maddison
2006-02-22 00:00:00
I have downloaded the trial version of HXTT DBF v2.1 to evaluate its potential working alongside our VFP6.0 programs. Everything looked fine until I tried to open a table indexed on the field FROM using the SELECT command. The Exception thrown is:
java.sql.SQLException: Can't parse index expression from
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.v.a(Unknown Source)
at com.hxtt.sql.dbf.b.for(Unknown Source)
at com.hxtt.sql.dbf.b.(Unknown Source)
at com.hxtt.sql.dbf.b.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.i.a(Unknown Source)
at com.hxtt.sql.dbf.d.a(Unknown Source)
at com.hxtt.sql.dbf.d.(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.a7.if(Unknown Source)
at com.hxtt.sql.cm.a(Unknown Source)
at com.hxtt.sql.cm.a(Unknown Source)
at com.hxtt.sql.a7.a(Unknown Source)
at com.hxtt.sql.a7.a(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.y.executeQuery(Unknown Source)
at DBTest.getAlias(DBTest.java:46)

the offending line in DBTest.java is String sqlRead = "SELECT * FROM emailout"

when the index is removed the command works, but when I try to execute the query:
String sqlRead = "SELECT * FROM emailout WHERE emailout.from = 'xxxxx'"
the following exception is thrown
java.sql.SQLException: Failed to parse: Stopped parse at from
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.f(Unknown Source)
at com.hxtt.sql.a7.k(Unknown Source)
at com.hxtt.sql.y.if(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.y.executeQuery(Unknown Source)
at DBTest.getAlias(DBTest.java:46)


Is there any way round this problem as we are interested in this product.
Re:HXTT DBF from field
HXTT Support
2006-02-22 00:00:00
Yeah. Because from is a SQL reserved word. You can try
SELECT * FROM emailout WHERE emailout."from" = 'xxxxx'
Or
SELECT * FROM emailout WHERE emailout.[from] = 'xxxxx'

If you have many tables with from column, we can supports it in sql. The HXTT DBF supports using DATE, TIME, TIMESTAMP, GROUP, ORDER, KEY, DESC, SEQUENCE, INCREMENT, MINVALUE, MAXVALUE, CACHE, CHECK, CYCLE, OTHER, SET, INT, and UPDATE directly in SQL now, although they're reserved words too.
Re:HXTT DBF from field
Ken Maddison
2006-02-22 00:00:00
Thanks for the quick response.
It has sorted the problem.

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