topic Object Lock duration beyond program termination. in Application Development and Automation Discussions

Object Lock duration beyond program termination.

kammaje_cis — Wed, 22 Jul 2009 09:58:00 GMT

Hi all,

As I understand the ENQUE_<object> will lock the object only for till the transaction/program terminates. Is there a way to get a lock beyond this?

My requirement is in Workflow, where I need to lock an object till an approval happens. This approval process might take days to happen, and the object should be locked till then. I experimented with the _SCOPE parameter and it did not help. Any ideas?

Thanks

Krishna

Re: Object Lock duration beyond program termination.

Sm1tje — Wed, 22 Jul 2009 10:07:31 GMT

well it sound better to me to use some sort of status. If objects has a certain status, then object can not be edited. Only after approval, you will change the status and editing is allowed.

Re: Object Lock duration beyond program termination.

Former Member — Wed, 22 Jul 2009 10:26:37 GMT

Hi,

Try this possible solution.

1) create a table which stores the detail workflow approval = YES or NO.

2) create a background job report which locks the object.

In this report ,put the following logic.

do .

select single approval

from new ztable created

into l_status

where.......

if l_status = YES (means approval done).

EXIT.

endif.

enddo.

3) This means the program will not stop untill the approval is done!!!

CHEERS!!!

Regards,

Vimal