Easiest way is probably using a date column in your DB table and pulling based on that, or if you are using a small DB like Access, you can pull based on the Autonumber (the higher numbered records are the newest).
Yes if I display everything from the database then I can sort the newest date first.. but I'm only displaying a number of records.. about 10 records and I need to get the most recently added record.. <BR>Someone suggested me to do it this way:<BR><BR>SELECT TOP 10 * from mytable ORDER BY date desc<BR><BR>But it doesn't work for me (I'm using Progress database). Is there any other way to get the last records first??<BR>Thanks.<BR>
It would produce this error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <BR><BR>[INTERSOLV][ODBC SequeLink driver][Progress]** Unable to understand after -- "DECLARE". (247) <BR><BR>It doesn't understand the "TOP 10" part.. I think it's not supported by progress database..<BR><BR>When I tried rs.movelast (instead of rs.movefirst) it would say:<BR>Rowset does not support fetching backward.<BR><BR>What else can I do..