Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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
   
   
   
Heng Xin Tian Tai Ltd. of Beijing City (abbr, HXTT)

HXTT DBF
ntx index question
olivier chen
2017-04-21 01:19:34.0
hello how can i run my ntx index file into dbf file i already have a cgp file with the name of the index . and did the fonction setfetchsize(int i) work ?
Re:ntx index question
HXTT Support
2017-04-21 08:44:45.0
You can read 6. The ntx can't be updated when I update the DBF file. at here. After your CGP file contains that NTX file name, you needn't to do more special operation.
ResultSet.setFetchSize() or Statement.setFetchSize() can work.
Re:Re:ntx index question
olivier chen
2017-04-25 00:47:34.0
how to fetch data from database according to an index ?
Re:Re:Re:ntx index question
HXTT Support
2017-04-26 05:22:38.0
It will utilize index automatically according to your where clause.
Re:Re:Re:Re:ntx index question
olivier chen
2017-04-26 06:50:34.0
I have try but i don't know how to do, could you give me an example please ?
I have a dbf file named AFAIRE.DBF and an index file AFAIRED.NTX . In my dbf file i have (codint varchar, datecour date, dateinit date, real varchar, ref varchar) and my index sort the data like this codint+dtos(datecour)+real+dtos(dateinit) which are the keys.
i call the NTX file in a CGP file named AFAIRE.CGP so it's already refresh automatically the index.
when i do "SELECT * FROM AFAIRE" the index is not automatically appli and the resultSet return the data like in the database
But now i would like to fecth the data of my dbf file to sort the result with my NTX index
Re:Re:Re:Re:ntx index question
olivier chen
2017-04-26 06:56:21.0
for exemple:
imagine i have 3 rows in my database:
CODINT DATECOUR DATEINIT REAL REF

zzzz 25-01-95 04-12-96 aaa aaa
aaaa 25-01-95 04-12-96 aaa aaa
bbbb 25-01-95 04-12-96 aaa aaa

when i do "SELECT * FROM AFAIRE" i get the same result in the same order but i want to use my index to have with a "SELECT * FROM AFAIRE [...]" something like this:
CODINT DATECOUR DATEINIT REAL REF

aaaa 25-01-95 04-12-96 aaa aaa
bbbb 25-01-95 04-12-96 aaa aaa
zzzz 25-01-95 04-12-96 aaa aaa
Re:Re:Re:Re:Re:Re:ntx index question
olivier chen
2017-04-27 05:13:52.0
java.sql.SQLException: Can't parse index expression delflag()+CODINT+DTOS(DATECOUR)+REAL+DTOS(DATEINIT)
at com.hxtt.b.al.a(Unknown Source)
at com.hxtt.sql.dbf.y.a(Unknown Source)
at com.hxtt.sql.dbf.m.i(Unknown Source)
at com.hxtt.sql.dbf.m.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.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.x.a(Unknown Source)
at com.hxtt.sql.by.if(Unknown Source)
at com.hxtt.sql.by.a(Unknown Source)
at com.hxtt.sql.d1.a(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.by.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.if(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.executeUpdate(Unknown Source)
at Test.main(Test.java:25)
Re:Re:Re:Re:Re:Re:Re:ntx index question
HXTT Support
2017-04-29 01:24:30.0
First, it will utilize index when where clause contains indexed expression, or order by indexed expression.

Secondly, delflag() is a unknown function so that HXTT DBF throws exception. You can use DELETED() or use Extend SQL functions

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 1999-2017 Heng Xin Tian Tai Ltd. of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap