I'm, going to use SPT


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