following query works with excel.what is suppose do is after executing this query it should update value of $intCRMIncidentRequest$ in the excel sheet,query is working fine and correct
but sometimes execution takes place but this qurey does not update varible value in the excel sheet.
as this issue happens sometimes i am not able to find the reason or solution of this issues
can anyone help me with issue
UPDATE Sheet1$$] SET Status] = '$intCRMIncidentRequest$' WHERE Trim((Txn_Posted_Date])='$strTransactionDate$' AND UCase(Trim((Cr_Dr]))='CR' AND UCase(Trim((Description]))='$strTDesc$' AND Transaction_Amount] = $intAmount$