Skip to Content
0
Former Member
May 10, 2010 at 07:56 AM

Insert/modify : It won't commit?!

36 Views

Hi guys,

I am trying to insert several line into a Z db table.

I use : modify zmm_modif from zmm_modif.

I do it 10 times with different value but i get only 1 line into my DBtable.

After searching forums, i tries several solutions :

I added : COMMIT WORK AND WAIT.

or 'COMMIT WORK'

or CALL FUNCTION 'DB_COMMIT'.

But none of these solutions work.

The only addition that works is : 'WAIT up to 1 seconds'. But it takes ages (10 sec) to do the job.

Its the same result with insert or modify.

Anyone has an idea?

Thank for your help.

Olivier.