there is no "last record"

what is a table? a table is a set of records.
what is a set? a set is a bunch of similar items in no particular order.

it does not any make sense to say "last record" w/o a sort order.

if you want to track the record you last inserted, you need to use a auto increment id field. then use "top 1" and "order by id desc" clauses to get the last inserted record.

所有跟帖： 

• Solutions for future ... -DBDB- ♀ (361 bytes) () 06/30/2004 postreply 20:20:58

• 回複：there is no "last record" -tryyyyyy- ♀ (47 bytes) () 06/30/2004 postreply 20:45:40

• 回複：there is no "last record" -tryyyyyy- ♀ (82 bytes) () 06/30/2004 postreply 21:55:46

• This is for SQL Server, not -smartll- ♀ (60 bytes) () 07/01/2004 postreply 01:02:23

• It work in Access -tryyyyyy- ♀ (0 bytes) () 07/01/2004 postreply 07:01:29

• 回複：回複：there is no "last record" -MD/PHD/IT- ♀ (213 bytes) () 07/01/2004 postreply 13:35:43