>>
>>Ok, I can use it if I have my table opened, like that:
>>
>>USE MyTable
>>Locate For...
>>If !Found()
>> Append Blank
>>Else
>> GATHER NAME ...
>>EndIf
>>
>>
>>But, is there a way to use it like INSERT FROM ... NAME...?
>
>Like this?
LOCATE FOR ...
>IF FOUND()
> GATHER NAME ...
>ELSE
> INSERT FROM ... NAME...
>ENDIF
>
Sorry, my english is terrible! ;-)
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
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte