This looks promising. However, what would you do if several records in MyTable match KeyField? Would you recommend SET SKIP, or expand the SELECT to include a subquery (and get all PKs of table MyTable)?
Hilmar.
>
SELECT KeyField from AnotherTable Into Cursor KeyCursor
>SET RELATION TO KeyField INTO Mytable
>SCAN
> ...
>ENDSCAN
>
>>I want to process, in a SCAN loop, all records that satisfy a given condition. The condition is most easily expressed as a SELECT - SQL - but what is the best way to combine the two?
>>
>>
>>Pseudocode:
>>
>>SCAN where KeyField in (SELECT KeyField from AnotherTable)
>> ...
>>ENDSCAN
>>
>>
>>The processing itself is too complicated to place into a single INSERT - SQL command.
>>
>>Basic criteria: 1) code should not be too messy, 2) it should be reasonably fast.
>>
>>TIA, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)