Home » Developer & Programmer » Forms » Vertical Scroll bar
Vertical Scroll bar [message #281833] Mon, 19 November 2007 08:03 Go to next message
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;
  • Attachment: screen.doc
    (Size: 71.00KB, Downloaded 793 times)
Re: Vertical Scroll bar [message #281888 is a reply to message #281833] Mon, 19 November 2007 18:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Populate block using cursor
http://www.orafaq.com/forum/m/605/67467/?srch=populate+block+cursor+create_record#msg_605
and my feelings about it.
http://www.orafaq.com/forum/m/134237/67467/?srch=populate+block+cursor+create_record#msg_134237
Another one of my rants.
http://www.orafaq.com/forum/mv/msg/74947/213213/67467/#msg_213213

Just use a standard master-detail.

David
Previous Topic: connect DataBAse for Form Level
Next Topic: Oracle Blob Display Error
Goto Forum:
  


Current Time: Fri Dec 02 20:43:46 CST 2016

Total time taken to generate the page: 0.16410 seconds