| CalendarProblem [message #414177] |
Mon, 20 July 2009 13:39  |
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
