[V4Rb 2] converting VSet to VCursor

[Frank Schima]

Hi guys,


On Jul 2, 2005, at 2:40 PM, Ruslan Zasukhin wrote:

> On 7/2/05 9:00 PM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
>
>>> CY> Once I have a VSet, I'd like to then get a VCursor to get the
>>> fields I
>>> CY> want for the found set of records.  Is there a way to do it  
>>> other
>>> than
>>> CY> "SELECT * FROM Table1 WHERE recID IN (recid1, recID2, ...,
>>> recID500)"?
>>>
>>> Why not? You can mention RecID as any other field in the "WHERE"
>>> clause.
>>>
>>
>> It seems rather inelegant.  Perhaps we could use a VTable method
>>
>> Function Cursor(fields() as String, recIDs as VSet) as VCursor.
>>
>
> I see what you mean Charles.
> If I not mistake such feature request present in Mantis.
>
> I have see similar thing in the 4D.
>
>     SetToArray
>     ArrayToSet.
>
> 4D names a kind of cursor as Set.

I could have sworn that I made *exactly* that feature request a while  
back but I cannot find any mention of it in Mantis. It would likely  
be much faster than the SQL way.

Charles, would you do the honors of creating a new feature request  
for this?


Best regards,
Frank Schima