<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6603.0">
<TITLE>Vset to VCursor</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi Ruslan,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I apologize if this is in the documentation already but I just can't find it if it is.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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…</FONT></P>
<P><FONT SIZE=2 FACE="Arial">SELECT FirstName, LastName, ZipCode FROM Person WHERE RecID IN (insert my final Vset here)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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…</FONT></P>
<P><FONT SIZE=2 FACE="Arial">myCursor = SqlSelect("SELECT FirstName, LastName, ZipCode FROM Person WHERE RecID IN (:1)", myVset)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">-John</FONT>
</P>
</BODY>
</HTML>