Question Allow update only unposted transactions

[eshack]

Dear All,

From the below update command I want to achieve that records will be updated only if field VH_FUEL_Approaval is not clicked. I mean only status of unposted now needs to be updated; The field VH_FUEL_APPROVAL is binded in DetailView as check box. Now select,insert and update all are working fine without this check; My aim is not to allow to update records once posted. When I update the bolded line I am getting error as 'syntex error near where'


UpdateCommand="UPDATE [VEH_FUEL_CONSUMPTION] SET [VH_FUEL_BILLNO] = @VH_FUEL_BILLNO, [VH_REG_NO] = @VH_REG_NO, [VH_FILL_DT] = @VH_FILL_DT, [VH_RUNFROM_KM] = @VH_RUNFROM_KM, [VH_RUNTO_KM] = @VH_RUNTO_KM, [VH_LTR_CONSUM] = @VH_LTR_CONSUM, [VH_AMT_CONSUM] = @VH_AMT_CONSUM, [VH_FUEL_POSTING] = @VH_FUEL_POSTING, [VH_SUPPLIER_CODE] = @VH_SUPPLIER_CODE, [VH_FUEL_APPROVAL] = @VH_FUEL_APPROVAL WHERE [VH_FUEL_ID] = @original_VH_FUEL_ID AND (([VH_FUEL_BILLNO] = @original_VH_FUEL_BILLNO) OR ([VH_FUEL_BILLNO] IS NULL AND @original_VH_FUEL_BILLNO IS NULL)) AND (([VH_REG_NO] = @original_VH_REG_NO) OR ([VH_REG_NO] IS NULL AND @original_VH_REG_NO IS NULL)) AND (([VH_FILL_DT] = @original_VH_FILL_DT) OR ([VH_FILL_DT] IS NULL AND @original_VH_FILL_DT IS NULL)) AND (([VH_RUNFROM_KM] = @original_VH_RUNFROM_KM) OR ([VH_RUNFROM_KM] IS NULL AND @original_VH_RUNFROM_KM IS NULL)) AND (([VH_RUNTO_KM] = @original_VH_RUNTO_KM) OR ([VH_RUNTO_KM] IS NULL AND @original_VH_RUNTO_KM IS NULL)) AND (([VH_LTR_CONSUM] = @original_VH_LTR_CONSUM) OR ([VH_LTR_CONSUM] IS NULL AND @original_VH_LTR_CONSUM IS NULL)) AND (([VH_AMT_CONSUM] = @original_VH_AMT_CONSUM) OR ([VH_AMT_CONSUM] IS NULL AND @original_VH_AMT_CONSUM IS NULL)) AND (([VH_FUEL_POSTING] = @original_VH_FUEL_POSTING) OR ([VH_FUEL_POSTING] IS NULL AND @original_VH_FUEL_POSTING IS NULL)) AND (([VH_SUPPLIER_CODE] = @original_VH_SUPPLIER_CODE) OR ([VH_SUPPLIER_CODE] IS NULL AND @original_VH_SUPPLIER_CODE IS NULL)) AND (([VH_FUEL_APPROVAL] = @original_VH_FUEL_APPROVAL) OR ([VH_FUEL_APPROVAL] IS NULL AND @original_VH_FUEL_APPROVAL IS NULL)) WHERE @original_VH_FUEL_APPROVAL IS NULL ">

 

[eshack]

Please advise

please advise where is the mistake?????? ; the error is where condition !!!! please advise me how i can build where condition to check the current record is posted(approved) status or not?

 

[Menthos]

You have two WHERE statements in your query. Try changing the second WHERE to AND.

 

[eshack]

Dear menthos, You are right. Thank you. Now it is working.