you will need to do Replace Sequence WITH strSeq IN mytable or use the UPDATE Command UPDATE mytable set Sequence = strSeq WHERE idcol = idval or do an insert statment.

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