[V4RB] sql question

[Ruslan Zasukhin]

on 2/19/04 10:59 PM, Dave Parizek at dave at Parizek.com wrote:

>> 
> 
> I have a single table query where I wish to set the contents of 1
> field in the table = the corresponding contents in another field.
> Below, Sku and Location are fields in table Item.
> 
> update Item set Sku = Location

Not works in 1.x

> When I do this all the values in the Sku field become the literal
> string "Location" instead of the values from Item.Location.
> 
> Do I have the syntax wrong?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------