Thanks Sergey!


>>I was wondering if there is a way to use UPDATE-SQL with objects like we can use INSERT FROM xxx NAME oObj. Something like that:
>>

>>Update MyTable Where MyId = m.nId Set Name oMyObject
>>

>>
>>Look... just one line. I know that it doesn't work, but I just ask because maybe someone had some idea about it...
>>
>>VFP TEAM could implemented it in UPDATE-SQL when they did the same thing to INSERT-SQL
>
>
>You can do the same in 3 lines of code existing commands
>

>*Update MyTable Where MyId = m.nId Set Name oMyObject
>SCAN FOR MyId = m.nId
>  GATHER Name oMyObject
>ENDSCAN
>

>The INSERT command allowed to insert from arrays or memory variables since long ago. Adding a NAME clause was just extension of it existing functionality. The UPDATE comand never allowed bulk update from arrays or memory variables.