John Baird
Coatesville, Pennsylvania, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Nah .. she got the correct answer anyway.... At least I can admit when I'm wrong..
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only