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
HXTT driver doesn’t support function .. now
Ralph Lance
2011-10-20 07:42:19.0
I'm evaluating your HXTT DBF JDBC driver with the demo Visual FoxPro database Northwind. Two tables have functions in the definition of the primary key, like ALLTRIM(UPPER(territoryid)). Apparently, this is legal in VFP. When I try to use these tables, though, I get the error:

HXTT driver doesn’t support function ALLTRIM(UPPER(territoryid)) now

Could you please advise.

Thank you.
Re:HXTT driver doesn’t support function .. now
HXTT Support
2011-10-20 08:15:09.0
>HXTT driver doesn’t support function ALLTRIM(UPPER(territoryid)) now
Those function is supported. Maybe it throw that exception for other reason.
Passed test with the following sql:
create index aaaaaaa on listprec (ALLTRIM(UPPER(NOM_LISTA)));
select top 1 NOM_LISTA,ALLTRIM(UPPER(NOM_LISTA)) from listprec;

If possible, you can zip the Nortwind database, and email us it.
Re:HXTT driver doesn’t support function .. now
HXTT Support
2011-10-20 08:26:28.0
Found a Northwind database, please let us know your sql
Re:Re:HXTT driver doesn’t support function .. now
HXTT Support
2011-10-20 08:31:31.0
Passed test with NorthWind sample of VFP9 Beta
select * from customerdemographics;
select * from territories;

What's your HXTT DBF version or sql?
Re:Re:Re:Re:HXTT driver doesn’t support function .. now
Ralph Lance
2011-10-20 08:33:35.0
Digging out the information now...
It'll take a few minutes.
Re:Re:Re:Re:Re:HXTT driver doesn’t support function .. now
HXTT Support
2011-10-20 08:48:22.0
Received you database sample, and it seems normal through sql or SQuirrel SQL client.
Re:Re:Re:Re:Re:Re:HXTT driver doesn’t support function .. now
Ralph Lance
2011-10-20 08:56:16.0
Wow! You are fast! :)
I had to debug code in order to get the query being sent. The program builds the query dynamically. It looks like this:

SELECT "territories".* FROM "territories" ORDER BY "ALLTRIM(UPPER(territoryid))"

I see the problem, now. The program makes an assumption that the primary key and index column names are plain column names without any functions or operators. It just took the contents of the primary key column name and surrounded it as-is with quotation marks. If I remove those, then it works. :)

Thanks for your help. The problem is on this end then. I'll report what great service I received to my boss during the evaluation phase!
Re:Re:Re:Re:Re:Re:Re:HXTT driver doesn’t support function .. now
HXTT Support
2011-10-20 09:03:47.0
You should use SELECT "territories".* FROM "territories" ORDER BY ALLTRIM(UPPER(territoryid))

" is using to seperate reserved word in sql.
Re:Re:Re:Re:Re:Re:Re:HXTT driver doesn’t support function .. now
HXTT Support
2011-10-20 09:15:55.0
>>HXTT driver doesn’t support function ALLTRIM(UPPER(territoryid)) now
>" is using to seperate reserved word in sql.
Sorry for the mislead error message. Because HXTT DBF think it's a variable name of "ALLTRIM(UPPER(territoryid))", but HXTT driver supports array column (used in Cobol) and embeded UDF constant function, so that give an unclear prompt. We will changed it to "Invalid function or variable:" in the next version.

Thanks for your praise.

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