>Here's a little additional info, in case it helps. And man, do I need help...
>
>One user is in my Orders form adding new orders and another is in my Invoice form billing older orders. The person who is entering new orders is doing nothing with the orders that the person doing the invoicing is invoicing.
>
>The person who is posting invoices is getting the following error message:
>
>Program : PROCEDURE FORM1.PAGEFRAME1.PAGE4.CMDPRINT.CLICK I:\PONTOTOC\INVOICES.SCT
>Line : 365
>Error # : 109
>Message : Record is in use by another user.
>
>Here is the code that's generating the error in my Invoicing form. I'm scanning through my order header file (ORD_HEAD) to see if there are any remaining detail lines in ORD_LINE. If there aren't, I'm deleted the record in ORD_HEAD:
>
> sele ord_head
> go top
> scan
> if !indexseek(ord_head.order_no,.f.,"ord_line","order_no")
> dele
> endi
> endscan
>
>Line #365 (the line of code that's causing the error) is DELE.
>
>The table ORD_HEAD is opened in the Data Environment of my Invoices form with the Exclusive property set to .f.. The table ORD_HEAD is also opened in the Data Environment of my Orders form with the Exclusive property set to .f..
>
John
FWIW
>What could be causing this error? The person who's entering orders is not entering the order that the person who's posting invoices is deleting through the posting process, so the record SHOULDN'T be "in use" by anyone else.
Aye but what BUFFERING do you have. If TABLE buffering then the fact that somneone has it open for browsing would preempt a delete attempt by another. wouldn't it?
Also, your code has no provision for actually testing for another user having the record before attempting to delete it.
Is there any RI on the order lines table that might prevent deleting their parent?
...
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.