Re: Oracle Objects for OLE, missing functionality

In article <ian.hollier.146.0015D449_at_daytonoh.ncr.com>, Ian Hollier <ian.hollier_at_daytonoh.ncr.com> wrote:
>Looking at Oracle Objects for OLE, and especially at the Dynaset object, how
>do you search the dynaset based on a key. I have a programming need to search
>the dynaset to see if a record exists so that I know if to add a new row or
>update the row in the dynaset. Can any one spread any light on this problem.
If you are asking whether or not OO4O supports, the FIND* methods, then, as the doc says, it does not. My suggestion would be to create a query using a parameter that mathces your key. Create a dynaset out of that and check the dyn.RecordCount property(or better yet check to see if EOF and BOF are true which means an empty dynaset). Then change the parameter value and refresh the DYNASET (dyn.refresh-check the doc) to see if that record is available. That's a close workaround.
>
>Thanks Ian
>
>P.S. Anyone had any success doing stored procedures through OO4O, specifically
>data access.
OO4O supports calling SPs using EXECUTESQL and supports scalar in/out vars using the parameters collection. You basically need to put a BEGIN/END around your call and use it in EXECUTESQL(FYI-this is the same way the EXECUTE command works in SQL*Plus). Check the Examples under ExecuteSQL, Add, Remove and some others to see an example of how to call and SP. (Oh-return types of record and table aren't supported).

-Keith Received on Wed Apr 12 1995 - 00:00:00 CEST