How to update several fields in one Select statment?Is possible?

[XaRz]

Hi folks,

I need to update several prices of several objects that I have the ID:

Object1:ID1
Object2:ID2
OBJECT3:ID3
....

I want to update a field from each obecjt with a relation:

Object1rice1
Object2rice2
Object3: price3
...

There is a way to do this in one statement?
Thanks for your help.

 

[PHV]

Where are price1, price2, price3, ... coming from ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[XaRz]

From manual input.

I have the relation:


Id_object1------->price1
Id_object2------->price2
Id_object3------->price3
Id_object4------->price4
Id_object5------->price5

In a sheet. And IdobjectX and priceX doesn't have any logic relationship, it's only a external decision.

 

[PHV]

How is your problem related to ANSI_SQL ?