Click here to Skip to main content
15,914,642 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionHow can I take the most recent record from a table? Pin
waner michaud5-Jul-10 9:53
waner michaud5-Jul-10 9:53 
AnswerRe: How can I take the most recent record from a table? Pin
EliottA5-Jul-10 10:51
EliottA5-Jul-10 10:51 
GeneralRe: How can I take the most recent record from a table? Pin
waner michaud5-Jul-10 11:20
waner michaud5-Jul-10 11:20 
AnswerRe: How can I take the most recent record from a table? [modified] Pin
Dr.Walt Fair, PE5-Jul-10 11:18
professionalDr.Walt Fair, PE5-Jul-10 11:18 
GeneralRe: How can I take the most recent record from a table? Pin
waner michaud5-Jul-10 11:31
waner michaud5-Jul-10 11:31 
GeneralRe: How can I take the most recent record from a table? Pin
Dave Kreskowiak5-Jul-10 18:16
mveDave Kreskowiak5-Jul-10 18:16 
GeneralRe: How can I take the most recent record from a table? Pin
Dr.Walt Fair, PE6-Jul-10 3:55
professionalDr.Walt Fair, PE6-Jul-10 3:55 
AnswerRe: How can I take the most recent record from a table? Pin
riced6-Jul-10 6:47
riced6-Jul-10 6:47 
Question: Is it possible to have two (or more) entries with the same date?
If so, then sorting on date descending and selecting first one (e.g. by using top) is not guaranteed to get you the most recent entry.
If the ID field is autogenerated then perhaps the max of that is a better candidate?
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.

GeneralRe: How can I take the most recent record from a table? Pin
waner michaud6-Jul-10 7:06
waner michaud6-Jul-10 7:06 
QuestionMDI Parent and Child issues Pin
Simon_Whale5-Jul-10 0:21
Simon_Whale5-Jul-10 0:21 
AnswerRe: MDI Parent and Child issues Pin
Tom Deketelaere5-Jul-10 2:12
professionalTom Deketelaere5-Jul-10 2:12 
GeneralRe: MDI Parent and Child issues Pin
Simon_Whale5-Jul-10 2:29
Simon_Whale5-Jul-10 2:29 
GeneralRe: MDI Parent and Child issues Pin
Tom Deketelaere5-Jul-10 3:01
professionalTom Deketelaere5-Jul-10 3:01 
QuestionIs it the right approach to speed up the copy process? Pin
Sonhospa3-Jul-10 12:33
Sonhospa3-Jul-10 12:33 
AnswerRe: Is it the right approach to speed up the copy process? Pin
riced3-Jul-10 19:42
riced3-Jul-10 19:42 
GeneralRe: Is it the right approach to speed up the copy process? Pin
Sonhospa4-Jul-10 0:03
Sonhospa4-Jul-10 0:03 
GeneralRe: Is it the right approach to speed up the copy process? Pin
riced4-Jul-10 0:57
riced4-Jul-10 0:57 
GeneralRe: Is it the right approach to speed up the copy process? Pin
DaveAuld4-Jul-10 1:19
professionalDaveAuld4-Jul-10 1:19 
NewsRe: Is it the right approach to speed up the copy process? Pin
Sonhospa4-Jul-10 4:39
Sonhospa4-Jul-10 4:39 
GeneralRe: Is it the right approach to speed up the copy process? Pin
Аslam Iqbal4-Jul-10 11:13
professionalАslam Iqbal4-Jul-10 11:13 
GeneralRe: Is it the right approach to speed up the copy process? Pin
Sonhospa5-Jul-10 21:12
Sonhospa5-Jul-10 21:12 
GeneralRe: Is it the right approach to speed up the copy process? Pin
Аslam Iqbal6-Jul-10 11:19
professionalАslam Iqbal6-Jul-10 11:19 
GeneralRe: Is it the right approach to speed up the copy process? Pin
DaveAuld4-Jul-10 11:31
professionalDaveAuld4-Jul-10 11:31 
GeneralRe: Is it the right approach to speed up the copy process? Pin
Sonhospa5-Jul-10 21:12
Sonhospa5-Jul-10 21:12 
QuestionDatagrid to database Pin
.NetDeveloper092-Jul-10 23:37
.NetDeveloper092-Jul-10 23:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.