Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Paradox
HXTT dont fetch same rows as MS Access
Bjarne Pedersen
2006-10-09 04:23:51.0
I have tryed to fetch some rows from my paradox database, both with hxtt and MS Access, problem is that MS Access fetch the right rows but hxtt dont! :(

Following is from HXTT:
SELECT "Art (F,K,T,O,L)", "TOF nummer", "Dato" FROM Gemtofh WHERE "Dato" ='20061009' AND "Art (F,K,T,O,L)"='A'
and that return nothing, and i know for sure that there is 5 records in my db.

Following is from MS Access:
SELECT GemtofH.[Art (F,K,T,O,L)], GemtofH.[TOF nummer], GemtofH.Dato
FROM GemtofH
WHERE (((GemtofH.[Art (F,K,T,O,L)])="A") AND ((GemtofH.Dato)="20061009"));

And that returns:
Art (F,K,T,O,L) TOF nummer Dato
A 81712 20061009
A 169511 20061009
A 612232 20061009
A 612248 20061009
A 6600996 20061009

If you need it i can upload my database to you

Regards
Bjarne Pedersen
Denmark
Re:HXTT dont fetch same rows as MS Access
HXTT Support
2006-10-09 04:31:53.0
You can upload it:) I guess that should be an index issue. Of course, if your Data is a date type, you should try:
SELECT "Art (F,K,T,O,L)", "TOF nummer", "Dato" FROM Gemtofh WHERE "Dato" ={d '2006-10-09'} AND "Art (F,K,T,O,L)"='A'.

BTW, [] is supported too. You can use:
SELECT GemtofH.[Art (F,K,T,O,L)], GemtofH.[TOF nummer], GemtofH.Dato
FROM GemtofH
WHERE (((GemtofH.[Art (F,K,T,O,L)])='A') AND ((GemtofH.Dato)={d '2006-10-09'}));
Re:Re:HXTT dont fetch same rows as MS Access
Bjarne Pedersen
2006-10-09 04:44:59.0
Problem is that my "Dato" field is a number field and not a Date field (its from our economy system and they really dont know how to use a database :@ )

im uploading a zip file now (gemtofh.zip - 13.5 mb) then you can have a look and tell me why i cant get it to work :)

Bjarne Pedersen
Re:Re:Re:HXTT dont fetch same rows as MS Access
HXTT Support
2006-10-09 05:05:49.0
I'm downloaing it. That file will be removed at once after I download it.
Re:Re:Re:Re:HXTT dont fetch same rows as MS Access
HXTT Support
2006-10-09 06:22:17.0
Tested. It's an index issue in fact :)
After run ONCE "reindex Gemtofh.X0C on Gemtofh ;reindex GemtofH.XG6 on Gemtofh ;",

Both of
SELECT "Art (F,K,T,O,L)", "TOF nummer", "Dato" FROM Gemtofh WHERE "Dato" ='20061009' AND "Art (F,K,T,O,L)"='A' ;

SELECT GemtofH.[Art (F,K,T,O,L)], GemtofH.[TOF nummer], GemtofH.Dato FROM GemtofH WHERE (((GemtofH.[Art (F,K,T,O,L)])='A') AND ((GemtofH.Dato)='20061009'));

work normally:)
Re:Re:Re:Re:Re:HXTT dont fetch same rows as MS Access
HXTT Support
2006-10-09 06:23:39.0
That data has been removed from hxtt site. I will remove your data from my PC after 24 hours if you needn't more support:)
Re:Re:Re:Re:Re:Re:HXTT dont fetch same rows as MS Access
Bjarne Pedersen
2006-10-09 06:30:26.0
Its working like a charm now, thx a lot :)

Bjarne

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