>Hi, thanks for the response.
>I first tried SQL Update and then tried xbase Replace and got the same result. I don't think the record pointer is being moved...

USE <table> ORDER <order tag>
SET MULTILOCKS ON
CURSORSETPROP("Buffering", 3, <table>)

*** Find your record
*** SEEK, locate or however, then do rest

lnRec = RECNO()
? 'Record: ' + TRANSFORM(RECNO())
? 'Value: ' + <table.field>
? 'Now Updating'
*** No Where clause will update all records, moving record pointer
UPDATE <table> SET <field> = <value> ;
   WHERE <filter condition>

*** Check record pointer
? 'Record: ' + TRANSFORM(RECNO())

*** Go to original record, check value
GO lnRec
? 'Value: ' + <table.field>

*** Revert information
TABLEREVERT(.T.)

*** Check value again
? 'Value: ' + <table.field>

*** Change record second time
UPDATE <table> SET <field> = <value> ;
   WHERE <filter condition>

*** Check record pointer
? 'Record: ' + TRANSFORM(RECNO())

*** Go to original record, check value
GO lnRec
? 'Value: ' + <table.field>

*** Revert information
TABLEUPDATE(.T.)

*** Check value again
? 'Value: ' + <table.field>