Ruslan, Trevor<br><br>thanks for the link and the code. I'll give both a try and see how I go.<br><br>Very much appreciated<br><br><div class="gmail_quote">On Wed, Jun 16, 2010 at 9:49 PM, Trevor DeVore <span dir="ltr"><<a href="mailto:lists@mangomultimedia.com">lists@mangomultimedia.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">On Jun 15, 2010, at 8:59 PM, Kay C Lan wrote:<br>
<br>
> At his point all I'm trying to replicate is revDataFromQuery; ie<br>
> extract actual data, not a cursor.<br>
<br>
</div>Use VDatabase_SQLSelectRecords. Here is the code I use in the<br>
dbconn_retrieveQueryAsData command of SQL Yoga. Hopefully it is helpful.<br>
<br>
if sConnectionsA[ pConnectionA["database"] ][ pConnectionA["name"] ]<br>
["valentina client connection id"] > 0 then<br>
                 put "kServerSide" into theLocation<br>
             else<br>
                 put "kClientSide" into theLocation<br>
             end if<br>
             if the keys of pBindingsA is not empty then<br>
                 put VDatabase_SQLSelectRecords( theConnectionID,<br>
pSQL, theLocation, "kReadOnly", "pBindingsA", 1, -1, \<br>
                         pColDel, pRowDel, "", "", "", "") into pOutData<br>
             else<br>
                 put VDatabase_SQLSelectRecords( theConnectionID,<br>
pSQL, theLocation, "kReadOnly", "", 1, -1, \<br>
                         pColDel, pRowDel, "", "", "", "") into pOutData<br>
             end if<br>
             put _valentinaError(theConnectionID) into theError<br>
<font color="#888888"><br>
--<br>
Trevor DeVore<br>
Blue Mango Learning Systems<br>
ScreenSteps: <a href="http://www.screensteps.com" target="_blank">http://www.screensteps.com</a><br>
Releasable Revolution Resources for Developers: <a href="http://revolution.bluemangolearning.com" target="_blank">http://revolution.bluemangolearning.com</a><br>
</font><div><div></div><div class="h5"><br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></blockquote></div><br>