Comments by Member 13734676

Member 13734676 22-Mar-18 1:15am View

:) .....yes will try it out with a small query before my actual query which is a bit complex

Member 13734676 21-Mar-18 12:22pm View

Hi Maciej, Thanks for your reply.

What happens to the NEXT=null, ACTIONDATE=SYSDATE? Will they work as normal update query

Member 13734676 21-Mar-18 10:35am View

Hi Maciej will the below code work? because it as sysdate which gives the current date while updating the row.

cmd.CommandText = "Update Tbl_Active_User set LoginDate=sysdate where Username=:username"

or should i add a parameter for the logindate as Datetime.Now

Comments by Member 13734676 (Top 3 by date)