>In msAccess you can replace a value in a table with a simple
>

>rstRawData.Sequence = strSeq
>

>
>Somewhere on UT I think I saw a similar assignment in VFP. (or am I imagining things?) I am porting an msAccess app to VFP and it would be simpler if I didn't have to change all these to REPLACE statements. But the original code doesn't seem to work. What am I missing?

Don,

One option you have is that:

select rstRawDataAlias
scatter memo name rstRawData
rstRawData.Sequence = srSeq
gather name rstRawData memo

In this way, you just need to change is that table alias name and add scatter and gather.

HTH