Hi , I am very new to this. I need help updating a table. Here is what I am doing.
I have a table("TransferRequest") that has some records and Date_Transferred field.. Every 10 mins I need to check a view("v_UnTransferred") that checks the untransferred requests from the table and transfer them. After this process, the Date_Transferred field in the table needs to be updated with the time it was transferred. Here is my code:
Dim rsSched As New ADODB.Recordset Dim cmd As New ADODB.Command