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.
|
|
|
|
Goto Forum:
Current Time: Sat Mar 01 02:49:03 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
