Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
sys_context in the view and using in oracle forms
CREATE OR REPLACE VIEW QC_DAILY_VW
(DEPT_ID, QC_TYPE_ID, QC_SUBTYPE_ID, QC_DATES, CONTROL_NO)
AS
select a.dept_id,a.qc_type_id,
a.qc_subtype_id,b.qc_dates
from qc_dept_subtypes a,qc_daily b
where a.dept_id = b.dept_id(+)
and a.qc_subtype_id = b.qc_subtype_id(+)
and a.qc_type_id = b.qc_type_id(+)
--and a.dept_id = 11
and b.qc_dates(+) = to_date(sys_context('mydat
-------------------
In my forms I call this in the post query
my_pkg.test_context(:qc_de
First time the form is blank. when I close it and reopen then the data displays. Why is this happening.
(DEPT_ID, QC_TYPE_ID, QC_SUBTYPE_ID, QC_DATES, CONTROL_NO)
AS
select a.dept_id,a.qc_type_id,
a.qc_subtype_id,b.qc_dates
from qc_dept_subtypes a,qc_daily b
where a.dept_id = b.dept_id(+)
and a.qc_subtype_id = b.qc_subtype_id(+)
and a.qc_type_id = b.qc_type_id(+)
--and a.dept_id = 11
and b.qc_dates(+) = to_date(sys_context('mydat
-------------------
In my forms I call this in the post query
my_pkg.test_context(:qc_de
First time the form is blank. when I close it and reopen then the data displays. Why is this happening.
Asked:
-
5
1 Solution
it's the "POST" query that is the problem
the view is based on the value of the context, so it must be set BEFORE you read the view.
The context won't change unless you change it, so setting it once on the form is sufficient.
to fix it, set it before the form's query executes
the view is based on the value of the context, so it must be set BEFORE you read the view.
The context won't change unless you change it, so setting it once on the form is sufficient.
to fix it, set it before the form's query executes
I tried to set it in the when new block instance trigger of the view block. It still does not work. I commented tyhe line in post query and now I have it only in the when new block, but nothing works. But when I requery it brings the data.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Be seen. Boost your question’s priority for more expert views and faster solutions
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
sys-context.doc