| NBT-how to maintain the entered data after exequery? [message #250689] |
Tue, 10 July 2007 20:59  |
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  |
bahubcd
Messages: 40
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
