Votes
Answers
Views
Question
2
1
56
Case description: IF ELSE statements not working correctly: See code following code example: If testargs("LocDate") = "sysdate" Then msgbox "LocDate = sysdate" Set MyRecordSet14= DBO.Execute(" Update locdate set locdt = (SELECT TO_CHAR(SYSDATE) FROM dual) where ...
3
1
32
IF/ELSE statement is not working: See below code example: If dtSystemDate = dtMyDate Then msgbox "dtSystemDate = dtMyDate" Set rcMyRecords = DBO.Execute("Update recorddate set locdt = (SELECT TO_CHAR(SYSDATE) FROM location) where locnbr = " & my_Variable.Item("LocNbr...