Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table buffering error
Message
From
05/11/2001 16:17:02
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00577587
Message ID:
00577610
Views:
18
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform