Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE From Name / MemVar
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01106940
Message ID:
01106972
Views:
26
>>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform