AbsolutePosition in Oracle Data Objects or ROWNUM?

  I am developing an application using the Oracle Data Objects against an Oracle 8 server. In my application I need to sync up the position in a dynaset with the position in a ComboBox (not a databound control). If I do a FindFirst on the dynaset, I need to figure out the absolute position of the found record in the dynaset. In DAO's RecordSet object there is an AbsolutePosition property, but there doesn't appear to be an equivalent in the Oracle Data Objects OraDynaset object. As an alternative, my DBA suggested using the ROWNUM keyword in my query to populate a field with the sequential number. This almost works, except my query has an ORDER BY clause and the ROWNUM is generated before the ORDER BY is processed. I think my best bet is to somehow have a calculated field which is incremented with each row. Is this possible? Any suggestions? BTW, in case I didn't make it obvious, I can't afford to run through the dynaset populating a sequence field. That process is too time consuming. Any help is greatly appreciated.

Darrell

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 27 1999 - 16:45:34 CST