Home » Developer & Programmer » Forms » how to display data in a tabular block that have a display item,
how to display data in a tabular block that have a display item, [message #340917] Thu, 14 August 2008 22:16 Go to next message
dynz18
Messages: 5
Registered: May 2008
Junior Member
can somebody help me how to display data from a tabular display item? pls..,
code:
BEGIN 
   --GO_BLOCK('INQBENEF'); 
   --the go block is working if there is a navigable item
   --but i dont want the data to be alter so im not using it.
   OPEN que_benef;

   FIRST_RECORD;

   LOOP
      FETCH que_benef
       INTO vph_lastname, vph_firstname, vph_middlename, nage, vph_relat;

      EXIT WHEN que_benef%NOTFOUND;
      :inqbenef.dblastname := vph_lastname;
      --all item is a "display item"
      :inqbenef.dbfirstname := vph_firstname;
      :inqbenef.dbmiddlename := vph_middlename;
      :inqbenef.dbage_benef := nage;
      :inqbenef.dbrel_to_ph := vph_relat;
      NEXT_RECORD;
   END LOOP;

   RAISE form_trigger_failure;

   CLOSE que_benef;
END;


please..,
sorry for the informal message.., im just new here.., also thanks for any reply.., Surprised


[EDITED by LF: formatted the code and applied [code] tags]

[Updated on: Fri, 15 August 2008 07:06] by Moderator

Report message to a moderator

Re: how to display data in a tabular block that have a display item, [message #340954 is a reply to message #340917] Fri, 15 August 2008 03:07 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

you fetched those records into block items, in a tabular display i suppose, then what's the problem?
And why "RAISE FORM_TRIGGER_FAILURE"? for what purpose?

Please explain your problem in details, and follow posting guidelines.
Re: how to display data in a tabular block that have a display item, [message #340984 is a reply to message #340917] Fri, 15 August 2008 07:14 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, you've written that piece of code. What makes you unhappy with it? Is there any error message? If so, which one?

By the way, is there any special reason for not creating a simple database block and populating it with Forms default behaviour - executing a query? As it seems that you don't want users to modify data, run the form in QUERY ONLY mode (or set data blocks INSERT / UPDATE / DELETE ALLOWED properties to "no").

Display items (which are, I guess, part of another table, different from the data block base table) can/should be populated in the POST-QUERY trigger.
Previous Topic: horizontal scroll bar for a tab page
Next Topic: checkbox error
Goto Forum:
  


Current Time: Mon Feb 10 00:19:45 CST 2025