Re: Select Row [message #370299] |
Tue, 17 August 1999 05:17 |
Chris Hunt
Messages: 27 Registered: March 1999
|
Junior Member |
|
|
Sadly, AFAIK, there's no built-in way of retrieving the last-entered row of a table. It's a principle of relational databases that the order in which data is entered should not be significant.
If it is significant to your application, you'll have to write a database trigger to either timestamp or sequence-number each row as it is inserted.
-- Chris
|
|
|
Re: Select Row [message #370300 is a reply to message #370299] |
Wed, 18 August 1999 03:13 |
FJD
Messages: 1 Registered: August 1999
|
Junior Member |
|
|
Possibly the followunf query might help you
select * from x where rowid = (select
max(rowid) from x)
|
|
|