OraFAQ Forum: Forms » how to preview this field

Home » Developer & Programmer » Forms » how to preview this field (form developer 6i second release)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to preview this field [message #280275]

Tue, 13 November 2007 01:02

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

Dear all
i created a view as following

SELECT COUNT (emp.sex), sex.TYPE
FROM emp, sex
WHERE ((sex.ID = emp.sex))
GROUP BY sex.TYPE

now i went to the form developer to create a form for this view
only one field appears (sex.type) and the other one is not allowed(count(emp.sex)
so how can i make a form to preview the both fields

best regards

Report message to a moderator

Re: how to preview this field [message #280278 is a reply to message #280275]

Tue, 13 November 2007 01:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

COUNT(*) should have an alias in order to use it as a column in a form:

CREATE VIEW v_sex AS
  SELECT s.type, 
         COUNT(e.sex) cnt   --> something like this
  FROM emp e, sex s
  WHERE s.id = e.sex
  GROUP BY s.TYPE;

Report message to a moderator

Re: how to preview this field [message #280287 is a reply to message #280275]

Tue, 13 November 2007 01:38

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

thanks brother for ur cooperation
i tried and did what did u tell me
and the same problem appears
one filed is ok the other appears disabled so i cant select it in the fields that i want them to appears in the form devloper

best regards

Report message to a moderator