Home » Developer & Programmer » Forms » NBT-how to maintain the entered data after exequery?
NBT-how to maintain the entered data after exequery? [message #250689] Tue, 10 July 2007 20:59 Go to next message
kuligma
Messages: 1
Registered: July 2007
Junior Member
NBT-how to maintain the entered data after exequery?

I'm adding an NBT field, to filter the query of my form, but after the query has been executed, the value of the nbt field is gone... how can i maintain the value of it, so I can use it, for another query?

Thanks.
Re: NBT-how to maintain the entered data after exequery? [message #252231 is a reply to message #250689] Wed, 18 July 2007 04:26 Go to previous messageGo to next message
bahubcd
Messages: 36
Registered: July 2007
Location: Bangalore
Member
after the query is executed, you may be refreshing the form or something like that. Please find the name of that text field in the PL/sql code in the form and see if you are changing the field values to null.

Still if it doesnt work, then the alternative is:
Create a program unit to store the varaibles only. Declare a varaible with the type same as you field. Now while executing the query, you can set the value of this varaible to that of the field. And later use this variable(which has the field value) for another query.

Eg:
Step_1>
PACKAGE INTERNAL_VARIABLES IS
GP_multiview_not_initialized BOOLEAN := TRUE;
GP_button_pressed VARCHAR2(15);
GP_query_source VARCHAR2(1000);
GP_secondary_desc_ind SYSTEM_OPTIONS.SECONDARY_DESC_IND%TYPE;
GP_COMMIT_REQ varchar2(1) := 'N';
END;


Step_2>
INTERNAL_VARIABLES.GP_COMMIT_REQ := 'Y';


I think this should resolve your query, Please correct me if i am wrong
Re: NBT-how to maintain the entered data after exequery? [message #253163 is a reply to message #250689] Mon, 23 July 2007 00:50 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Put your NBT data in another block (eg CONTROL) then when you go to your data block (eg MAIN) and do a Query the data in your control block will not be cleared.

David
Previous Topic: list item
Next Topic: Can I Saves any field in oracle database 8.1.5 in asci characters using forms 6i
Goto Forum:
  


Current Time: Sun Dec 04 02:52:47 CST 2016

Total time taken to generate the page: 0.05699 seconds