Search results for query: *

That's a very good tip,dgo. I suggest to add TRUNC in your tip to get all dates of the given month. select TRUNC(to_date('01-JAN-02','dd-MON-yy'),'MON') + rownum - 1 day from all_objects where rownum <= to_char(add_months(TRUNC(to_date('01-JAN-02','dd-MON-yy'),'MON'),1)-1,'dd')

where do you want these dates to appear? IN LOV or in List Item, or somewhere else, I cant think of any solution which can achieve what you want In a single query. probably you may have to use PL/SQL block. so where/why you want to have all the dates? I am asking so that if there could be...

in addition to the w-n-r-i, you will have to set the tooltip for field1 on when validate of field2.

select DATEFIELD from TABLENAME where to_char(DATEFIELD,'MON-YYYY')=TO_CHAR(SYSDATE,'MON-YYYY');

BJCooperIT, What if post is issued instead of commit in your suggetion? Vsimmons, why after posting the control is passed to another form? Could you find out the reason?

If this item is database item, then you dont have to do anything to store this item in database, as you have given the formula, value will be calculated on its own. and if it is not database item, u will have to write insert/update statment.

just a thought.. why have you not used date as datatype, and u have used three number fields for day/month/year?!

Hi sumitha what ehpt has suggested is correct in my view. you need to create a parameter list and then add parameter by following syntax Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO'); this would work. correct me if i am wrong. Best Luck, Dharmesh