Re: Update statement not working

can u paste the code

Here's the update statement:

  UpdateCommand="UPDATE PROJECT_EOC SET COMMENTS = :COMMENTS, UPDATED_BY =
:UPDATED_BY, UPDATE_DATE = :UPDATE_DATE WHERE (TO_CHAR(BEGIN_YEAR) =
:BEGIN_YEAR)">
             <UpdateParameters>
                 <asp:Parameter Name="COMMENTS" />
                 <asp:Parameter Name="UPDATED_BY" />
                 <asp:Parameter Name="UPDATE_DATE" />
                 <asp:Parameter Name="BEGIN_YEAR" />

Also, everything works fine in QueryBuilder, but does not work when I run the
application.

put a breakpoint and debug it u may get some information where u r getting the
problem

AnonymousJones:

as per my understanding in Oracle Query Builder you are updating some records
which is not reflecting in you application.

 

Please ensure that after firing UPDATE command from SqlBuilder/ SqlDeveloper you
need to Commit your transaction as Oracle Automatically not committing all you
updation  automatically as SQL SERVER. 


 

Hope this Help :-) 

Thanks,

``````````````

j@y

 

--> Mark as Answer if this helps you.