How to use to indexes in a Table


2005-07-12 05:04:59 AM
cppbuilder94
Hi,
I have a TTable with one field as Date and one field as TTime
and I set both fields as Secondary Indexes.
I need to list the table so it shows the latest date and early time:
For example:
//I need to get this
July 06, 2005 09:00AM // instead of 04:00PM
July 06, 2005 04:00PM // instead 09:00AM
June 27, 2005 09:00AM
June 27, 2005 10:00AM
etc.
I currently call the Date index to list by Date but the Time I guess shows the opposite, as follow
//This is what I get - no time deccendent listing
July 06, 2005 04:00PM
July 06, 2005 09:00AM
June 27, 2005 09:00AM
June 27, 2005 10:00AM
Am I missing something?
thanks
Freddy