-
1. Re: FRM-40505: unable to perform query
Just a wild guess regardless what you are trying to do;
you have set the "ename" "Databse Item" property to "Yes". That's why the Form is unable to query your table, it's not finding a column called "ename" in the table.
Set it to "No" it should work.
Tony -
2. Re: FRM-40505: unable to perform query
Thanks for your reply tony but i need to populate the details for the field ename also
prasad -
3. Re: FRM-40505: unable to perform query
You need to have some sort of relation between the DEPT Block.
Which is your master block, EMP or DEPT?? -
4. Re: FRM-40505: unable to perform query
Guess what you have to do is assuming ( if I inderstood your issue corretly, else please explain in detail)
dept table as master block and emp as detail block
on the detail block's empno field/item property sheet , there is a column called " copy value from item"
put in a value there as "dept.empno" ( again assuing the empno is the joining factor) or you have to do for all the columns that you want to link/join.
Thanks
sheik -
5. Re: FRM-40505: unable to perform query
Here is my issue
i have two data blocks emp,dept(with the same values in the database.i am giving the basetables for ur understanding.)
i have joined the two datablocks with deptno as common column.
and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas.
i want to display the values for all the above mentioned columns along with dname also.
i have tried as you told but it is not exucuting the value for dname.if i keep dname as non database item.it is only executing the columns for emp -
6. Re: FRM-40505: unable to perform query
my master table was dept(as same as the basetables)
deptno is my common column -
7. Re: FRM-40505: unable to perform query
Here is my issue
You're talking about DNAME or ENAME ????
i have two data blocks emp,dept(with the same values
in the database.i am giving the basetables for ur
understanding.)
i have joined the two datablocks with deptno as
common column.
and displaying empno,ename,job,sal,comm,mgr,hiredate,
and copyied dname from dept in one frame on canvas.
i want to display the values for all the above
mentioned columns along with dname also.
i have tried as you told but it is not exucuting the
value for dname.if i keep dname as non database
item.it is only executing the columns for emp -
8. Re: FRM-40505: unable to perform query
ok dname was the column i want to execute along with emp columns according to my criteria.
i was sorry for not explaining u correctly -
9. Re: FRM-40505: unable to perform query
Thanks for your reply tony but i need to populate
the details for the field ename also
prasadok dname was the column i want to execute along with emp columns according to my > criteria.
There's a big difference between ename and dname, first I suggest you read [url http://blogs.oracle.com/shay/2007/03/02]The 10 Commandments on OTN Forum posting and the Forum's [url http://forums.oracle.com/forums/help.jspa]FAQ.
i was sorry for not explaining u correctly
and to populate the DNAME value, use the POST-QUERY trigger. -
-
11. Re: FRM-40505: unable to perform query
i have same problem but with another way
i have 2 table employees & departments
departments is master
and employees
when i to do execute worked
bud i added one text item named tot
and made a trigger on commission_pct
post_change
select :salary +nvl(:commission_pct,'0') into :tot from dual;
ok
but now when do execute
have this error -
12. Re: FRM-40505: unable to perform query
Make tot a display item and in your post-change
:tot := :salary + nvl(:commission_pct,'0'); -
13. Re: FRM-40505: unable to perform query
i have an error FRM-40505: unable to perform query want solution plz -
14. Re: FRM-40505: unable to perform query
After you compile the form
If it is 6i then press
shift+f1
IF it is forms 10g then press
ctrl + shift + e
and paste the errors
