Insertion of field into the database table.

[Former Member]

Hi experts,

I am executing a program; with this program I am inserting the field into the database table.

I wrote commit after insert. I checked in the debugging and database table too it is inserting successfully after commit.

But after complete execution of the program the entry is deleting from the database table.

Please let me know what can be the problem?

Thanks in advance.

1. Krishna #

[Former Member]

Are you using INSERT or MODIFY? If MODIFY, you may be changing an existing entry not inserting a new one.

rob

[Former Member]

Rob,

its INSERT only..

1. Krishna #

[Former Member]

Once it is inserted whether u r deleting some where from teh table.

Paste the part of the code used for INSERTING.

[Former Member]

somewhere in your program you might have used delele statement.check it,

reward this point.

[Former Member]

HI,

I guess you are inserting the entry into table and saying commit work. Are you updating the standard table. If it is yes just pass the value to the table buffer then and the end of the program it will be updated successfully.

Thanks

Raghavendra

[Former Member]

Hi kumar,

thanks for the information.

could you please tell me how to pass the value to the table buffer then insert in to table?

#krishna#

[Former Member]

put a breakpoint , debug and checkout where that entr is getting cleared