Home » Developer & Programmer » Forms » Query on date in Forms.
Query on date in Forms. [message #375449] Wed, 25 October 2000 12:15 Go to next message
Prapoorna
Messages: 6
Registered: October 2000
Junior Member
Hi,

I have a date field(base table item) in Forms and i want to query the table on the date. When the query is executed it gives the message '0 records retrieved' even though there are records in the table for the date queried.

I guess it is because of the timestamp attached to the date, it is not able to retrieve the records. However if the seconds value(in HH:MM:SS) is 00 then the record is retrieved and if the seconds value is anything apart from 00 then it shows the above message.
How to i solve this and query the table on a specific date from Forms.

Thanks.
Re: Query on date in Forms. [message #375460 is a reply to message #375449] Fri, 27 October 2000 10:30 Go to previous message
snehal
Messages: 8
Registered: October 2000
Junior Member
Try this :

modify your where clause in pre-query trigger using set_block_property so that it looks something like this :
where trunc( date_column ) = :block_name.item_name
Previous Topic: integrity constraint violations while inserting values
Next Topic: ORA-06553: PLS-320
Goto Forum:
  


Current Time: Thu Mar 28 06:33:48 CDT 2024