FROM CLAUSE QUERY, how to construct?
GusoraJan 24 2007 — edited Jan 24 2007Have always used the data block wizard so am probably missing something quiet simple. I have created a new form and am manually creating a simple test block. What i've done so far:
Block Properties
Database Data block: No
Enforce Primary Key: Yes
Query allowed: Yes
Query data source type: FROM clause query
Query data source name: select department_id, department_name from departments
Query data source columns: department_id (number), department_name (varchar2)
Created a canvas with and put two items, department_id (set as Primary key) and department_name on it.
When i run the form i get... FRM-41003 This function cannot be performed here.
What am i doing wrong and what steps should i be taking?
Gus
Oracle 10g