topic Re: Locking record in a table? in Application Development and Automation Discussions

Locking record in a table?

Former Member — Wed, 14 Sep 2005 06:34:19 GMT

Hi,

Here is my requirement.

I am updating equipment through transaction IE32. I am using BDC update using call transaction. Now before I do call transaction IE32 I need to check whether that particular equipment is locked or not. for that I am using enqueue_lockobject to lock the record in EQUI table. If sy-subrc returns 0 means record is locked & if it is not 0 that means reord in not locked. In case where record is not locked I will do BDC update using call transaction IE32 but as I have locked this particular record it is giving error saying equipment is locked. To solve this problem I have unlocked that record just before call transaction IE32.

Now the real query:

can I do bdc update using call transaction IE32 after I locked that particular record?

Or I need to unlock it before doing BDC update as I have done?

Plz help

Regards

Prafulla

Re: Locking record in a table?

Former Member — Wed, 14 Sep 2005 06:39:01 GMT

In general if you BDC, it will automatically lock the correcponding records. so no need to lock that externally.

regards

Re: Locking record in a table?

andreas_mann3 — Wed, 14 Sep 2005 06:41:56 GMT

Hi,

you need not to lock eqp.,

because i think SAP locks/Unlocks eqp. in Standard-TA.

if eqp. is locked you got an error message from :

 CALL TRANSACTION 'IE32' USING bdcdata MODE mod MESSAGES INTO itab.

Andreas

Re: Locking record in a table?

Former Member — Wed, 14 Sep 2005 09:11:59 GMT

Prafulla,

It is not necessary to lock the records before u carry BDC . Doing so will even result in the BDC failure (Intrenal Error Message type : unable to lock the record).

Thanks

Kam