form extension...filter

To discuss Oracle Forms & Reports related technical issues.
Post Reply
avicenna
Posts: 1
Joined: Sun Jan 24, 2010 4:23 pm
Location: Saudi Arabia

form extension...filter

Post by avicenna »

Hello all,

I am working in apps form extension.. started with the template form, adding required libraries and registering it..

everything working fine, just one thing i could not figure out how to do yet..

as any other oracle form, pressing F11 enable us to enter the query mode so we can add our filtering.

assuming that my for has the following fields:
full_name>>> database item
employee_no>>> database item
gender>>> non database item

gender is based on the decoding of the gender_code, female for 'F' & male for 'M'..

when i enter the query mode, any filter i add in the database item is working fine after pressing ctrl+F11..
in the other hand, if i filter the non database item to just retrieve all Males for example it would not be done (like if i did not enter male)

hope everything is clear
any help would be appreciated
thnx
fahdbahoo@yahoo.com
Posts: 3
Joined: Tue Feb 09, 2010 6:51 am
Location: Pakistan

Post by fahdbahoo@yahoo.com »

Non data base items are not included in querying data base.
if u want to query data base you can make a database item.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests