Re: Oracle Power Object: Problem with Standalone RecordSets

ericth_at_montrealnet.ca (Eric Therrien) wrote:

.. < snip >

>objMedClin = NEW DBRecordSet( CliniqueDataSession )
>strSQLSelect = "SELECT * FROM TEST_VIEW"
>objMedClin.SetQuery( strSQLSelect, FALSE )
>
>FOR x=1 TO objMedClin.GetRowCount()
> strTranslation = strTranslation & objMedClin.GetColVal( "NOM" ) & " = " & &
> objMedClin.GetColVal( "C_CLINIQUE" ) & CHR$( 13 ) & CHR$( 10 )
> objMedClin.GoNxtLine()
>NEXT x
>
>popClinMed.Translation = strTranslation
>popClinMed.UpdateList()

.. < snip >

I think you are missing the

   recordset.ReQuery()
   recordset.FetchAllRows()

which is an undocumented feature of OPO.

I had the same problem initially until I found a bulletin in the Technical Support of Oracle Home Page entitled "Using Standalone Recordset in PO". You can refer to in with URL http://www.oracle.com/support/bul/opo/1306.html

Hope this helped.

Mohamad Nazri Shuib                     E-mail: mnshuib_at_gware.po.my
GroupWare 2000 Sdn Bhd                  Tel: (603) 253-5331
19G Medan Setia 1                       Fax: (603) 253-9927