|
| |
|
|
evansforsyth
Posts: 277
Joined: 12/11/2001
From: Grande Prairie, Alberta, Canada
Status: offline
 |
"Go Next" record? - 8/16/2004 14:25:40
Is there some way, using the DRW, to select the next record? Say after the 10th record is displayed, (and if the 11th record was deleted) that the next query would show the 12th record?
I seem to remember a "Go Next" database command--is it available to us?
Thanks
Evans
_____________________________
Over the hill? What hill, where, when?
I don't remember any hill!
|
|
|
|
evansforsyth
Posts: 277
Joined: 12/11/2001
From: Grande Prairie, Alberta, Canada
Status: offline
|
RE: "Go Next" record? - 8/16/2004 23:52:21
Thanks
This is for a classroom tutorial--so I need to store the record number and use it when the students have all answered the current question.
Ended up using another DIW to select ID_nbr > ID_nbr current, limited to calling one record. And then storing it in a variable.
Really appreciate the help--am doing things I'd despaired of a few years ago!
Thanks
Evans
| |
|
|
|
aaronwiles
Posts: 200
Joined: 7/5/2004
From: Aaron Wiles
Status: offline
|
RE: "Go Next" record? - 8/23/2004 14:51:49
Syntax being "ORDER BY ID DESC" not "SORT BY ID DESC", you can also use "ORDER BY ID ASC" (ASC - Ascending, DESC = Descending).
_____________________________
You really never learn to swear until you get a computer.
| |
|
 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 
k¥ 
