Well,

If you're planning to use SPT and ordering the server to perform all processes remotely, sure. If you're planning to use views, then there's no need.

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