topic Re: Commit after Modify in Application Development and Automation Discussions

Commit after Modify

Former Member — Mon, 09 Feb 2009 09:09:35 GMT

Hi,

When i use the commend modify in program (to modify data base tables) i don't write commit and

The tables are update how?

Regards

Re: Commit after Modify

Former Member — Mon, 09 Feb 2009 09:11:31 GMT

Hi,

When u modify the table it will immediately effects to the DB table....it gets modify

the DB table immediately if field is already there or else it simply inserts the value to DB table without writing the commit stmt........

The DB table gets updated immediately...

Regards

Kiran

Edited by: Kiran Saka on Feb 9, 2009 10:15 AM

Re: Commit after Modify

Former Member — Mon, 09 Feb 2009 09:12:33 GMT

Hi,

Normally if session going to change(Internal->internal or internal->external) at that time you require to use commit.

even you can use roll back that changes too after using commit.

-Rick

Re: Commit after Modify

Former Member — Mon, 09 Feb 2009 09:14:50 GMT

Hi Michael,

While using INSERT, MODIFY , UPDATE, DELETE statements, to manipulate database table,

we dont need to give commit work.

When the program ends, automatically the data will be updated unless any runtime error comes.

if any runtime error comes, the "ROLL BACK" happens automatically.

So no need to write COMMIT WORK statement.

Regards,

Nitin.

Re: Commit after Modify

Former Member — Mon, 09 Feb 2009 09:17:55 GMT

Hi ,

The statement modify directly modifies the table and implicitly calls the commit work.... so if you don't want that to happen write this modify statement in form....endform...

and call that form using the statement

perform <form_name> on commit.

then until you dont mention commit work it will not update

Regards,

Siddarth

Re: Commit after Modify

Former Member — Mon, 09 Feb 2009 09:18:49 GMT

an program has its own logiacal unit of work.

when it is executed and accompolished it go for auto commit.

so it happenes

regards