Database table 'REGUP'

[Former Member]

Hi,

In program,

first partie: insert data into 'regup' table

second partie: i select data that i insert in first partie

the problem is that the result of my select is null while the data was inserted.

NB: If i put 'break point' between first and second partie the result is good

[vinod_vemuru2]

Hi Simin,

After INSERT statement put COMMIT WORK statement. But my question is if u already have the data available(Which u inserted) then why do u need to select the same data again?

Instead u can use the inserted data right???

Thanks,

Vinod.

Edited by: Vinod Reddy Vemuru on Jun 19, 2008 1:42 PM

[Former Member]

Keep a WAIT statement between them like

WAIT UP TO 2 SECONDS.

Regards,

Kiran Bobbala

[Former Member]

Thanks experts.

I put 'work', 'commit work', MF 'DB_commit', 'commit', etc... ---> no

but not 'WAIT UP TO 2 SECONDS.' this syntax is very very helpful thank y so much