Are you going to correct your post to Brenda?
>Thanks... learn something new everyday...
>
>
>
>>Try this
>>
>>------------------------------------------------------------------
>>* TestUpdateSubQuery.prg
>>
>>LOCAL i
>>
>>#DEFINE TEST_RECORD 10
>>
>>CREATE TABLE TestUpdate FREE ( ;
>> pkey i( 4 ), ;
>> datavalue i( 4 ) ;
>> )
>>
>>FOR i = 1 to 10 STEP 1
>> INSERT INTO TestUpdate ( pkey, datavalue ) ;
>> VALUES ( i, i )
>>ENDFOR
>>
>>SELECT * FROM TestUpdate
>>
>>SELECT * FROM TestUpdate WHERE pkey == TEST_RECORD INTO CURSOR rcurRefUpdate
>>
>>UPDATE TestUpdate ;
>>SET datavalue = GetNewValue() ;
>>WHERE pkey IN ( ;
>> SELECT pkey FROM rcurRefUpdate ;
>> )
>>
>>SELECT * FROM TestUpdate
>>
>>CLOSE ALL
>>
>>RETURN .T.
>>
>>
>>FUNCTION GetNewValue()
>>
>>RETURN 25
>>
>>----------------------------------------------------------------------
>>
>>This is a simple example, but it illustrates that a column in a subset of rows can be updated (to a single value) in this fashion.
>>
>>Hope this helps,
>>
>>John
-=Gary