Commit after Modify

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

HI

an program has its own logiacal unit of work.

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

so it happenes

regards