IF/Else statement not working
| ♥ 0 |
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") & "and locdtcd = ‘ABC"’) Else End If But BOTH msgboxes are being displayed!!
Marked as spam
|
Posted by |
Private answer
This usually happens when a statement within the IF/Else causes a run-time error. Double check your database connection setting and your query. You might also want to wrap your code in error-handling code. You can find instructions on how to do that here: http://blogs.msdn.com/b/ericlippert/archive/2004/08/19/error-handling-in-vbscript-part-one.aspx HP has a knowledge base article about this situation (note it can also happen in Select Case statements): Marked as spam
 Posted by Michaeldx (Questions: 17, Answers: 807) Answered on February 28, 2013 8:25 pm
|