>I am wanting to update a field in a product file so I am looking at the details of the Invoice and trying to update all of the prodcts. I have added this logic:
>
>Select * from InvoiceDetail Where Invoice_ID = InvoiceHeader.Invoice_ID and Deleted() = .F.
>Set MultiLocks On
>CursorSetProp('Buffering', 5, <b>'product'</b>)
>SCAN
> Seek (InvoiceDetail.Product_ID) In Product order Product_ID
> MessageBox(str(cursorgetprop("Buffering")),0,"Property?")
<b>select product</b>
Replace UseSeason with m.currentseason
>ENDSCAN
>
>I also have the "Set Multilock On" at the very begining of the program as well.
>When I get to this code I see in the messagebox I've added that the mode is 5.
>At the replace command I get the error "Function requires row or table buffering mode."
>
>Any ideas?
>Thanks
Hello Kenneth,
What table are you wanting to use for buffering? When your cursorSetProp() line is executed, your current work area is a cursor. See change in bold above. Also, many people consider it more reliable to SELECT a work area before doing a REPLACE.
HTH,
Steve Gibson