Home » Developer & Programmer » Forms » how to preview this field (form developer 6i second release)
how to preview this field [message #280275] Tue, 13 November 2007 01:02 Go to next message
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
Re: how to preview this field [message #280278 is a reply to message #280275] Tue, 13 November 2007 01:10 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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;
Re: how to preview this field [message #280287 is a reply to message #280275] Tue, 13 November 2007 01:38 Go to previous messageGo to next message
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
Re: how to preview this field [message #280294 is a reply to message #280287] Tue, 13 November 2007 02:01 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, you've done something wrong, because - it just works fine by default! See an example - both columns are accessible:

./fa/3380/0/
  • Attachment: v_empd.PNG
    (Size: 14.11KB, Downloaded 159 times)
Re: how to preview this field [message #280304 is a reply to message #280275] Tue, 13 November 2007 02:16 Go to previous message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
thanks brother its working fine

best regards
Previous Topic: How to call Oracle help on web
Next Topic: read data from seriel interface
Goto Forum:
  


Current Time: Sat Dec 03 22:12:51 CST 2016

Total time taken to generate the page: 0.07039 seconds