>>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

Thanks to both of you.

I think my easiest solution is to convert the access code

rstRawData.Sequence = strSeq

to the fox equivalent of

replace rstRawData.Sequence with strSeq


Thanks