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 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
Error on UNION
Nick Wold
2012-08-08 01:20:15.0
can you help me with the following error? Query returns records using nonJDBC driver but returns following error when running using JDBC driver with RazorSQL

Nick

ERROR: java.lang.NullPointerException
at com.hxtt.sql.bx.a(Unknown
Source)
at com.hxtt.sql.bx.a(Unknown Source)
at
com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown
Source)
at com.hxtt.sql.am.executeQuery(Unknown Source)
at
sun.reflect.GeneratedMethodAccessor32.invoke(Unknown
Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown
Source)
at java.lang.Thread.run(Unknown Source)

Error
Code: 393216

Query = Select
CHECK
From
GNDSALE
Where

TYPE = 2
UNION
Select
CHECK
From
GNDSALE
Where
TYPE
= 5
Re:Error on UNION
HXTT Support
2012-08-08 03:29:29.0
Failed to recur your issue through:
create table gndsale (check int, type int);
create index type on gndsale(type);
insert into gndsale values(22,2);insert into gndsale values(233,5);
Select CHECK From GNDSALE Where TYPE = 2 UNION Select CHECK From GNDSALE Where TYPE = 5;
Re:Re:Error on UNION
HXTT Support
2012-08-08 17:59:31.0
Please check whether you can recur your issue.
Re:Re:Re:Error on UNION
Nick
2012-08-08 18:18:01.0
I will retest tomorrow. Pacific Standard Time

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 | Sitemap