Click here to Skip to main content
16,005,697 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionHow to rebuild the resource? Pin
rushing25-May-05 21:27
rushing25-May-05 21:27 
GeneralImporting namespace / Dll Pin
C.Sathish25-May-05 21:27
C.Sathish25-May-05 21:27 
GeneralRe: Importing namespace / Dll Pin
toxcct25-May-05 22:35
toxcct25-May-05 22:35 
Questionmovi gif in vb6? Pin
a_yosef25-May-05 21:14
a_yosef25-May-05 21:14 
GeneralCRUD Application Pin
imshally8125-May-05 20:53
imshally8125-May-05 20:53 
GeneralRe: CRUD Application Pin
C.Sathish26-May-05 2:27
C.Sathish26-May-05 2:27 
GeneralCapture Date and Time Pin
imshally8125-May-05 20:50
imshally8125-May-05 20:50 
GeneralRe: Capture Date and Time Pin
Rizwan Bashir25-May-05 21:28
Rizwan Bashir25-May-05 21:28 
well you have to put this question in SQL Forum. But Since you are here So the solution is you have put the date and time in table either same or different.
add two fields in your same table..
InsertedOn and ModifiedOn.

Now in InsertedOn put default value GetDate() (* SQL function). and do not insert this through your code. it will automatically populate when record will be inserted.
when user will modify any record from ASP then in update query put the new date in ModifiedOn to keep the record of last updated record. For Modification you can also write the trigger. On after insert and there you can use the getdate function to update the modified date.

Option 2.
Create a new table and put these values inserted on and modifiedON in this table when any event occur on ASP page. like adding or modifying the record.




GeneralRe: Capture Date and Time Pin
imshally8126-May-05 0:01
imshally8126-May-05 0:01 
Generalmaped network drives Pin
_tasleem25-May-05 19:32
_tasleem25-May-05 19:32 
GeneralRe: maped network drives Pin
madfiddlerchris26-May-05 0:49
madfiddlerchris26-May-05 0:49 
GeneralBig Bug in ComboBox control Pin
rushing25-May-05 17:38
rushing25-May-05 17:38 
GeneralRe: Big Bug in ComboBox control Pin
Christian Graus25-May-05 17:40
protectorChristian Graus25-May-05 17:40 
GeneralRe: Big Bug in ComboBox control Pin
rushing25-May-05 18:26
rushing25-May-05 18:26 
GeneralRe: Big Bug in ComboBox control Pin
Christian Graus25-May-05 18:31
protectorChristian Graus25-May-05 18:31 
GeneralRe: Big Bug in ComboBox control Pin
rushing25-May-05 19:36
rushing25-May-05 19:36 
GeneralRe: Big Bug in ComboBox control Pin
Christian Graus25-May-05 19:38
protectorChristian Graus25-May-05 19:38 
GeneralRe: Big Bug in ComboBox control Pin
rushing25-May-05 21:24
rushing25-May-05 21:24 
GeneralRe: Big Bug in ComboBox control Pin
J4amieC25-May-05 22:09
J4amieC25-May-05 22:09 
GeneralRe: Big Bug in ComboBox control Pin
rushing25-May-05 22:39
rushing25-May-05 22:39 
GeneralRe: Big Bug in ComboBox control Pin
rushing25-May-05 22:41
rushing25-May-05 22:41 
GeneralRe: Big Bug in ComboBox control Pin
Christian Graus26-May-05 11:35
protectorChristian Graus26-May-05 11:35 
GeneralReading a txt file in textbox from listview Pin
WetRivrRat25-May-05 17:26
WetRivrRat25-May-05 17:26 
GeneralRe: Reading a txt file in textbox from listview Pin
Christian Graus25-May-05 17:38
protectorChristian Graus25-May-05 17:38 
GeneralRe: Reading a txt file in textbox from listview Pin
WetRivrRat26-May-05 2:53
WetRivrRat26-May-05 2:53 

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.