topic Database table 'REGUP' in Application Development and Automation Discussions

Database table 'REGUP'

Former Member — Thu, 19 Jun 2008 08:09:11 GMT

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

Re: Database table 'REGUP'

vinod_vemuru2 — Thu, 19 Jun 2008 08:11:46 GMT

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

Re: Database table 'REGUP'

Former Member — Thu, 19 Jun 2008 08:12:33 GMT

Keep a WAIT statement between them like

WAIT UP TO 2 SECONDS.

Regards,

Kiran Bobbala

Re: Database table 'REGUP'

Former Member — Thu, 19 Jun 2008 08:21:26 GMT

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