Re: help help help urgent

Not sure, but you could try adding a "SELECT FOR UPDATE... WHERE ID=<idval>" cursor to lock only the record you wish to update. In my apps, I always use COMMIT, rather than the POST command.

  JeffJ

micind wrote:

> Hi
> We are using oracle 8 and developer 5.0
> Background:
> Sales invoice entry form and sales order entry form both are running on
> different win-95 machines. Each form is using "POST" built in procedure of
> oracle.
> When a sales order number is queried, changed and posted on one computer(but
> not yet committed). The another user is working on sales invoice entry and
> trying to get items being ordered in different sales order other than the
> one posted by that user.
> Problem:
> The second user(one who is trying to prepare invoice) is getting message
> 'working.....' while getting sales order details. When the sales order
> details are committed, the invoice user get access to sales order details.
> Why?
>
> Invoice entry form contains sales_order_item block use only to query the
> items from sales_order_item table.
>
> sales_invoice table (sales_order_code) is referenceing sales_order_item
> table.
> Pls contact
> micind_at_bom3.vsnl.net.in
Received on Sat Aug 14 1999 - 10:35:56 CDT