Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Anybody expert in Forms9i ? Pls look.
Anybody expert in Forms9i ? Pls look. [message #76682] Sun, 13 April 2003 07:56
Staline Xavier
Messages: 1
Registered: April 2003
Junior Member
Error : - FRM-40505: unable to perform query.

In Forms9i, If block is based on a view which uses aggregate function and group by clause on running the form it displays error "unable to perform query". But the same thing works in Forms6i and it displays the records available in the view. Is it a bug in Forms9i OR is there any workaround.

e.g.
CREATE OR REPLACE VIEW view1 AS
SELECT col1,MAX(col2),MAX(col3)
FROM tab1
GROUP BY col1

Can replace above objects with suitable names and give it a try pls.
Previous Topic: Oracle HTTP server can't start...
Next Topic: PSP - DAD configuration Error
Goto Forum:
  


Current Time: Tue Sep 22 07:40:03 CDT 2020