True, I did.

The reason I want to stay with SQL is becuase I'm upsizing this
application to SQL Server shortly, and I want to get in the mindset
of SQL statements.



>>I'm trying to stay with SQL. Thanks
>
>You asked for the best way. If you're already on the record, it is inefficient for VFP to use Rushmore optimization to locate and then update that record.
>
>>
>>>http://fox.wikis.com/wc.dll?Wiki~ReplaceCommand~VFP
>>>
>>>>I'm on a record in a table. I want to do a SQL update to the current
>>>>record.
>>>>
>>>>

>>>>nRecId = Table.RecId
>>>>
>>>>UPDATE Table
>>>>  SET Field = cValue
>>>>  WHERE RecId = nRecId
>>>>

>>>>
>>>>Is this the best way?