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 Go to next message](/forum/theme/orafaq/images/down.png) |
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..,
[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 #340984 is a reply to message #340917] |
Fri, 15 August 2008 07:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
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.
|
|
|