WebDB call a Report from Calendar
Date: 2000/06/13
Message-ID: <3945EAEE.140163F7_at_loxinfo.co.th>#1/1
I have call a form from a Calendar to a report Calendar select
select
START_DAT,
WHO ||'<BR>'|| WHAT ||'<BR>'|| WHERE,
'BGV.R_EVENT_DETAIL.show?p_arg_names=T_EVENT.START_DAT&p_arg_values='||START_DAT as name_link,
null,
null as frame
from BGV.T_EVENT
order by T_EVENT.START_DAT
web call:
http://act01/WebDB/BGV.R_EVENT_DETAIL.show?p_arg_names=T_EVENT.START_DAT&p_arg_values=12-DEC-00
But in the START_DAT field I have also a time saved
like
to_date(12.12.2000 19:30, 'DD.MM.YYYY HH24:MI')
but the link finds no records bec of the time
if I save the date like
to_date(12.12.2000 00:00, 'DD.MM.YYYY HH24:MI')
or
to_date(12.12.2000, 'DD.MM.YYYY')
then the link works
is there a way to send the date and the time to the query
or do I have to make a new field in the Table for the Time.
hope works whit out.......
tanks alot Greg Received on Tue Jun 13 2000 - 00:00:00 CEST