Board index » off-topic » paradox can not run complex local sql?
hydonlee
Delphi Developer |
paradox can not run complex local sql?2003-07-17 01:37:33 PM off-topic9 I have a paradox7 table like this : FirstKey char(8) F001 char(4) F002 char(11) ..//about ten fields here , all simple type(char or numeric) and about 1,700 record in it. when i run " select * from Table1" , it is OK when i run " select * from Table1 order by FirstKey", it is wrong! all the record showed is the same one!!! the first record! and i delete 1,000 record , then run it , it is OK. I then add some condition "select * from Table1 where Firstkey like '%DT' or Firstkey like '%ST' order by FirstKey " it run WRONG AGIN!!! But When I remove the "order by FirstKey" , all the sql is OK. althouth i add the recordcount up to 2000. |