|
|
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)
HXTT Paradox
|
HXTT dont fetch same rows as MS Access |
Bjarne Pedersen |
2006-10-09 04:23:51 |
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 |
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 |
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 |
|
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 |
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 |
|
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 |
Its working like a charm now, thx a lot :)
Bjarne
|
|
|
Main
webmaster@hxtt.com