Pick date from Calendar on oracle Forms 10g


To insert date in text items  using calendar.





Here is the method with an example.

1#Open Forms Builder

2# Create Manual Block then press F2 to create canvas for this Block

3# Add Text item --name it to Date_Text  --Set DataBase to No --Set Fomat Mask to dd/mm/yyyy

4# Add Push Button

5#Add Object Library stndrd20 then drag and drop Components to Object Group n Block

6#Add PL SQL  Library  Calendar90.pll  then drag and drop  Date_lov(Spec&Body) to Program Units

7#Click  Push Button then press F11 then choose When_Button_pressed then write the following trigger :

       date_lov.get_date(sysdate,'date_text');



enjoy...



Here is the FMB Form runs without problems  and Here is the Object Library  and PL/SQL library

No comments:

Post a Comment

Remove unused Layouts in Oracle Apex

 Tables used : APEX_XXXXXXX.WWV_FLOW_REPORT_LAYOUTS APEX_XXXXXXX.WWV_FLOW_SHARED_QUERIES use the following query to delete unused Layouts. ...