DataSets and Forms (OpenInsight) [Revelation On-Line Wiki]

OpenInsight, Dave Ballance, Josef Obregon, Bob Carten

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

At 10 OCT 2001 04:44:44PM Dave Ballance wrote:

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?

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

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?

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

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

View this thread on the Works forum...