{{tag>category:"OpenInsight" author:"Dave Ballance" author:"Josef Obregon" author:"Bob Carten"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== DataSets and Forms (OpenInsight) ====
=== At 10 OCT 2001 04:44:44PM Dave Ballance wrote: ===
 
 
<QUOTE>
Perhaps I'm obtuse or just trying something silly. I am connecting to an oracle database with no problems and using

 dsmethod(handle,DS_EXECUTE$) or just F9 I get the dataset active and can page thru with prev, etc.



For some reason, nothing I try seems to work for setting to a specific row and getting it displayed onscreen. There is no unique key on the oracle table so and I cannot create one so dsmethod(handle,DS_FINDKEY$,rowid) is not an option - and it bombs when I try it anyway.



I tried using the send_event(@window,"DSOABS","WINDOW",handle,rownumber,1) to no avail.



Suggestions?
</QUOTE>
----

=== At 15 NOV 2001 04:48PM Josef Obregon wrote:  ===

<QUOTE>Dave, HOW TO GET TO CONNECT TO ORACLE, I NEED TO CONNECT MY APPLICATION IN OI 3.7 TO ORACLE8i BUT I CAN´T, COULD YOU HELP ME?

</QUOTE>

----

=== At 20 NOV 2001 04:40PM Bob Carten wrote:  ===

<QUOTE>Can you hand edit the Select script to accept replaceable parameters?

e.g.



SELECT thiscol,

       thatcol,

       tothercol

  FROM mytable

 WHERE  ( thiscol=:param1  )

   and  ( thatcol=:param2  )



Bob

</QUOTE>


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