Home » Developer & Programmer » Forms » CalendarProblem
CalendarProblem [message #414177] Mon, 20 July 2009 13:39 Go to next message
scaria.grg
Messages: 3
Registered: May 2009
Location: Kuwait
Junior Member
Hi all,
I am an appointment schedule form on forms 6i.i have successfully managed to attach the claendar.pll to my form but i need to create a relation between my database block blktrxappmnt (on the trx_appmnt table)which contains Appmnt_date column and the calendar date selected so that whichever the user selects,the trx_appmnt table is queried according to that...but till now no success....plz help.
Re: CalendarProblem [message #414646 is a reply to message #414177] Thu, 23 July 2009 01:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You need to get the value returned by the calendar routine into the 'where' clause of your block. If you ALWAYS have a date defined either SYSDATE or the date returned from the calendar then define that field in the 'where' clause via the Forms Builder. If the date is not always defined then you could use the 'set_block_property(,default_where,)' command when it is returned from the calendar.

David
Previous Topic: Missing Status Bar
Next Topic: Good Example for Dynamically populate third list based on first and Second
Goto Forum:
  


Current Time: Wed Dec 07 14:41:37 CST 2016

Total time taken to generate the page: 0.15478 seconds