topic Avoid create two record with first key equal simultaneously. in Application Development and Automation Discussions

Avoid create two record with first key equal simultaneously.

Former Member — Tue, 04 Jul 2006 14:38:18 GMT

Hi, the problem is:

I've done a program that register in a custom table that have more than one key field, i want avoid that this program (used by more dependents simultaneously) register more than one record with the first key field equal. How? I don't think that the ENQUEUE DEQUEUE statement is the solution.

Thanks for the answers.

Re: Avoid create two record with first key equal simultaneously.

RichHeilman — Tue, 04 Jul 2006 14:40:49 GMT

Sure you can, just create a lock object via SE11, enter all of the keys fields in the lock object. Then when calling the ENQUEUE funciton module, only pass the fields of the key that you wish to lock.

Regards,

Rich Heilman

Re: Avoid create two record with first key equal simultaneously.

Former Member — Tue, 04 Jul 2006 14:45:23 GMT

And the DEQUEUE statement is necessary to put in program?

Re: Avoid create two record with first key equal simultaneously.

RichHeilman — Tue, 04 Jul 2006 14:46:04 GMT

I would suggest it. Its always a good idea to release the lock explicitly.

Regards,

Rich Heilman