PRB: SEEK Finds Old and New Data With Optimistic Buffering

MORE INFORMATION

The Customer table, used in the Sample Code example, ships as sample data in Visual FoxPro 3.0x, 5.0x, and 6.0. Before running the program, use the SET DEFAULT TO command to point to the folder that contains the Customer table.

Steps to Reproduce Behavior

Issue the following commands in the Command window or create a .prg file and run the program.

Sample Code

   SET MULTILOCKS ON
   USE customer
   =CURSORSETPROP('Buffering',5)
   SET ORDER TO cust_id
   ?SEEK('AROUT')
   REPLACE CUST_ID WITH 'AROUS'
   ?SEEK('AROUT')
   ?SEEK('AROUS')
				

Note that the SEEK function returns true for the old value "AROUT" and for the new value "AROUS". Setting the buffering to optimistic row buffering or to pessimistic buffering, allows the SEEK function to find only the new value.