[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Accessing a DATASET connection and returning results. (OpenInsight Specific) ====
=== At 10 JUN 1998 11:49:55AM Steve C. wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I have an ODBC connection and dataset that works fine. 

I can create a popup and it returns the proper information.

I would like to put the data returned from the dataset into

a variable in an SSP. I've been looking at the "DS...."

functions but need some basic help.

In Basic+, how to I "lunch" the dataset, passing it a parameter

for the select "KEY". What function do I need to use to 

return the dataset data returned in a variable or multiple variables

for each column in the dataset.

TIA

Steve C.
</QUOTE>
----

=== At 10 JUN 1998 12:00PM Steve C. wrote:  ===

<QUOTE>Sorry, no I don't want to take it out to lunch.

i want to "Launch" the dataset.

Steve C.

</QUOTE>

----

=== At 12 JUN 1998 07:28AM Cameron Revelation wrote:  ===

<QUOTE>Hi Steve,



[i]I have an ODBC connection and dataset that works fine. I can create a popup and it returns the proper information. I would like to put the data returned from the dataset into a variable in an SSP. I've been looking at the "DS...." functions but need some basic help.

In Basic+, how to I "lunch" the dataset, passing it a parameter for the select "KEY". What function do I need to use to return the dataset data returned in a variable or multiple variables for each column in the dataset.[/i]



First instantiate the Connection Object:



Name=MY_CON"

hXO=XOInstance(Name)



Next instantiate the DataSet Object:



Name=MY_DSO"

hDS=DSInstance(Name, hXO)



Next execute the DataSet:



DSMethod(hDS, DS_EXECUTE$)



Next get the data (I copied this code from CS_SPY):



DSGetProperty(hDS, DS_RECORD$, List)



Lastly, clean up:



DSMethod(hDS, DS_DESTROY$)

XOMethod(hXO, XO_DESTROY$)



Suggestion:  Check out the source we publish.  The Client/Server spy (which would help you immensely to use it) is CS_SPY and the Client/Server Query Window is XO_QUERY.



Also, for directly executing SQL statements via ODBC etc. see the help for QryMethod ... there is a complete code snippet there.



Happy hunting,



Cameron Purdy

Revelation Software

</QUOTE>

----

=== At 13 JUN 1998 03:20PM The Skipper wrote:  ===

<QUOTE>What was that Saturday morning show years back where Gilligan and this other guy were loading up food on a space ship and he hit the launch instead of the lunch button and they ended up rocketing through space having all sorts of wacky, comical and hillarious adventures?







</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=D16561B1BE89681D8525661F0056F7F7|View this thread on the  forum...]]