When I am looking into the table ,the table is not updated

krishnasaikiah · New User Joined: 14 Mar 2007 Posts: 24 Location: gurgaon

Hi
I am facing a trouble in updating the table.
The problem is when i am executing the program and displaying the values after the update query , the values are updated values.

But when I am looking into the table ,the table is not updated.

Phrzby Phil · Posted: Thu May 17, 2007 5:42 pm

I thought rows are updated, not columns, and that it is the rows that are indexed.

krishnasaikiah · New User Joined: 14 Mar 2007 Posts: 24 Location: gurgaon

I am updating a particular column and it is not getting updated into the table but while i am executing the same update query in spufi, it is updating the table as desired.

Somebody if finds a clue to what should be the solution to my problem,please help .

thanks,
Krishna

dick scherrer · Posted: Sat May 19, 2007 2:36 am

Hello,

It sounds like your update is not being committed or something is specifically causing a rolback.

krishnasaikiah · New User Joined: 14 Mar 2007 Posts: 24 Location: gurgaon

ya thanks dick...
m trying to figure out the problem...though not yet successful.

kgumraj · Posted: Mon May 21, 2007 10:33 pm

Hi,

We too had similar problem, I feel it is with the variables declared.
Check whether the precomplilation step is warnig free, if it has waring dont ingnore that.

We approched this by moving FD variable to WS and then inserted/ updated it worked fine..

beter check this..

dick scherrer · Posted: Tue May 22, 2007 3:11 am

Hello,

As a test, you could put a checkpoint in the code just after the update and end the program. The update should be in the table at that time. If the updated data is in the row(s), the code is either never issiung as checkpoint or it is (or some called module is) issuing a rollback.

Good luck and we're here when you have news