Vset to VCursor

[Sims, John]

Hi Ruslan,

I apologize if this is in the documentation already but I just can't
find it if it is.

Let's say I am working with several unions/intersections of a few
different Vsets.  I finally get the Vset that represents the data I am
interested in.  Now what I would like to do is create a Vcursor
containing the records I have found.  Is it possible to do something
like...

SELECT FirstName, LastName, ZipCode FROM Person WHERE RecID IN (insert
my final Vset here)

The only way I can think to do it would be to turn the RecID's of the
Vset into an array and use the Binds feature of the SELECT statement.
That said, I think it would be a very cool feature to be able to just
pass in the Vset...

myCursor = SqlSelect("SELECT FirstName, LastName, ZipCode FROM Person
WHERE RecID IN (:1)", myVset)

If this is not currently possible and you agree that it would be cool
and it is doable, let me know and I'll be glad to add it to Mantis.

Thanks.

-John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20050121/4c92f866/attachment-0001.html