OraFAQ Forum: Forms » Vertical Scroll bar

Home » Developer & Programmer » Forms » Vertical Scroll bar

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Vertical Scroll bar [message #281833]

Mon, 19 November 2007 08:03

sweetgeegee27
Messages: 107
Registered: June 2005

Senior Member

I need help troubleshooting a vertical scroll bar on a data block. It is suppose to show three records but some of the records are repeated.

I have three sets on vertical scroll bars on different datablocks but whe I click on an empty row on the last datablock, it adds the same record.

I have attached a print screen for viewing. I have also inserted the trigger for the last data block below as follows:

BEGIN
  DECLARE
    CURSOR COLLECTION IS
      SELECT COL_CASE.COLLECTION_CASE_NO,
             TAX_TYP.TAX_TYPE_DESC,
             COL_CASE.OPEN_DATE,
             COL_CASE.CLOSE_DATE
        FROM COLLECTION_CASE COL_CASE,
             TAX_TYPE TAX_TYP
        WHERE COL_CASE.TAX_PAYER_NO = :TAX_P.TAX_PAYER_NO
        AND TAX_TYP.TAX_TYPE_NO = COL_CASE.TAX_TYPE_NO
        ORDER BY COL_CASE.COLLECTION_CASE_NO;
  BEGIN
    FOR COLLECTION_REC IN COLLECTION LOOP
      :COLLECTION.COLLECTION_CASE_NO := COLLECTION_REC.COLLECTION_CASE_NO;
      :COLLECTION.DSP_TAX_TYPE_DESC := COLLECTION_REC.TAX_TYPE_DESC;
      :COLLECTION.OPEN_DATE := COLLECTION_REC.OPEN_DATE;
      :COLLECTION.CLOSE_DATE := COLLECTION_REC.CLOSE_DATE;
    NEXT_record;
    END LOOP;
        --go_item('tax_p.tax_payer_no');
      END; 
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    NULL;
  WHEN OTHERS THEN
    CGTE$OTHER_EXCEPTIONS;
END;