Information générale
Catégorie:
Codage, syntaxe et commandes
>>Has anyone gotten anything like this to work in VFP?
>>If so, could you share some examples? Or any examples of Update/Select working together.
>>
>>UDPATE t1
>> SET rate = rate + (SELECT increase FROM t2 WHERE id = t1.id)
>>
>Steve, 9-01-98
>This is easy as pie in Fox.
>
>use t2 order tag id
>select 0
>use t1 && in any order
>set relat to id into t2
>browse fields id,rate,t2.id,t2.increase && look before you leap
>replace all rate with rate+t2.increase && perform the update
>
>I've used SQL, too, and it makes everything harder than in Fox.
>Good Luck,
>Gary Nemeth
Except we're not using any set relations....yup, it works but we
have to code to Oracle & SQL-Server back ends so the code above
is out. Thanks though.
Steve
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement