Re: Locking problem - URGENT
Date: 1997/06/23
Message-ID: <5ol1ks$qm7_at_info.csufresno.edu>#1/1
In article <01bc7f46$37cab100$baf1b1c6_at_panic.nis.criinc.com>,
Krishnan Ranganathan <kaa_at_criinc.com> wrote:
>LOCKING PROBLEM IN FORMS 4.5
>I have a form with two multi-record blocks :
>1. Block 1 contains following:
>
> Part Number Description
> P1 xxxxxxxxxxxxxx
>
>When user enter 'P1' at Part Number and press a 'Details' push-button, I
>retrieve all purchase requisitions for the entered part number, and
>transfer control to block-2 which has following fields :
> Purchase Requisition Number Status
> PR1 A
> PR2 A
>
>In 'WHEN-VALIDATE-ITEM' of Part Number field, I lock all the purchase
>requisition records displayed in block-2.
>The user can go back to Part Number field in block-1 , and change entered
>part number from say 'P1' to 'P2'. When the user does this ( changes part
>number from P1 to P2 ), I want to release locks on all the purchase
>requisition records for part P1 that were locked earlier.
>I cannot use 'CLEAR-FORM', 'EXIT-FORM', 'ROLLBACK', 'COMMIT' etc. at this
>stage in my application.
>
>How do I relase the locks. Please forward your answers to kaa_at_criinc.com
Just do a go_block('block-2'); and then Clear_Block(No_Validate); If this doesn't unlock the rows, then a Forms_DDL('Commit'); will do the job.
But why do you need to lock the rows in block-2? Inquiring minds want to know.
Steve Cosner
http://members.aol.com/stevec5088 Download QA, a dynamic data utility form-- Quick display and update access to any table. (QA upgrade now available) Received on Mon Jun 23 1997 - 00:00:00 CEST