|
| |
|
|
Welby
Posts: 59
Joined: 11/12/2002
Status: offline
 |
Select Statement Help..... - 11/27/2002 9:58:56
Is there a way to write a select statement to pull the highest number of a column? Or the last column written?
When people post to the database - I have a field (ID) that increases by one. I want to display a confirmation page with  this field (as well as the rest of the data they just posted) to them so they can make a note of the ID number for future reference. I looked at Spooky' s tutorials - and he has one for ACCESS, but it says it will NOT work with SQL (and of course that' s what I' m using).
Any help would be greatly appreciated
Thanks - Welby
|
|
|
|
Welby
Posts: 59
Joined: 11/12/2002
Status: offline
|
RE: Select Statement Help..... - 12/3/2002 9:58:49
What I ended up doing is a DRW and using a custom query that states:
select * from <TABLENAME>
ORDER BY " <ID-COLUMN>" DESC
I then did the display results in a table and showing only 1 record (which happens to be the last one since it' s in descending order) This looks like it will serve the purpose. I never had any luck with the @@Identity command.
Welby
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
