Information générale
Catégorie:
Codage, syntaxe et commandes
How about:
SELECT RECNO() as rn,* FROM sometable ORDER BY 1 DESC
this will work when there is only one FROM table.
>I want to scan through a table, but from bottom to top, not top to bottom. I could use SKIP -1 or I could sort the table in reverse order and then SCAN. Or is there a better way to read a table starting from the last record to the first record?
>
>Or I may just end up using a SELECT-SQL to find the matching records in the table, but the newest records are at the bottom and I need to search the newest records to the oldest records looking for matching criteria.
>
>For example - I could have a Title of a Document such as "Birth Certificate" in a MEMO field named TableofContents. It could appear in some or all or no records. If it appears in more than one record I need to grab the newest (date-wise) record that has the word "Birth Certificate" in the MEMO field. Or I could have other words such as "Death Certificate" and the same rules apply where I have to start at the bottom of the file and work my way to the top of the file looking for the newest record containing the words "Death Certificate." Or I could have "Birth Certificate" and "Death Certificate" in the same MEMO field along with other "Certificate" names.
>
>I hope you get the picture. It's hard to explain this one. Any ideas? Thanks for your help.
>
>Steve Kramer
>Tampa Bay, Florida
>"GO AWAY FLOYD!"
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement