Through ADOQuery connection ACCESS database, the database has a field ids, indexed, index called indexID, could you tell me how to write SQL statements
According to the field to find: SQL="select * from Table order by ID desc"; According to the index how to write? Reference other people's writing either complains
SQL="select * from Table order by indexID desc";
SQL="select * with index (indexID) from Table order by ID desc";
SQL="select * from Table order byindex (indexID) desc"; An error
Please grant instruction