[V4Rev]Valentina equivalent of revDataFromQuery

[Kay C Lan]

Ruslan, Trevor

thanks for the link and the code. I'll give both a try and see how I go.

Very much appreciated

On Wed, Jun 16, 2010 at 9:49 PM, Trevor DeVore <lists at mangomultimedia.com>wrote:

> On Jun 15, 2010, at 8:59 PM, Kay C Lan wrote:
>
> > At his point all I'm trying to replicate is revDataFromQuery; ie
> > extract actual data, not a cursor.
>
> Use VDatabase_SQLSelectRecords. Here is the code I use in the
> dbconn_retrieveQueryAsData command of SQL Yoga. Hopefully it is helpful.
>
> if sConnectionsA[ pConnectionA["database"] ][ pConnectionA["name"] ]
> ["valentina client connection id"] > 0 then
>                 put "kServerSide" into theLocation
>             else
>                 put "kClientSide" into theLocation
>             end if
>             if the keys of pBindingsA is not empty then
>                 put VDatabase_SQLSelectRecords( theConnectionID,
> pSQL, theLocation, "kReadOnly", "pBindingsA", 1, -1, \
>                         pColDel, pRowDel, "", "", "", "") into pOutData
>             else
>                 put VDatabase_SQLSelectRecords( theConnectionID,
> pSQL, theLocation, "kReadOnly", "", 1, -1, \
>                         pColDel, pRowDel, "", "", "", "") into pOutData
>             end if
>             put _valentinaError(theConnectionID) into theError
>
> --
> Trevor DeVore
> Blue Mango Learning Systems
> ScreenSteps: http://www.screensteps.com
> Releasable Revolution Resources for Developers:
> http://revolution.bluemangolearning.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20100617/f4e8a963/attachment.html>