Re: Help.. Date field on Master and detail blocks

From: Jure Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1996/06/21
Message-ID: <4qdqqb$jv3_at_sigov1.sigov.si>#1/1


Try changing properties for both fields from datatipe DATE to DATETIME. I think this should solve your problems.

Regards,
Jure Modic



kauj_at_lfs.loral.com (Joe) wrote:

>Hi,
> I am creating one FORM with master and detail block relations. The
> join condition likes "master.FIELD1 = detail.FILED2".
 

> Both FILED1 and FILED2 are in "MMDDYYHHMISS" format and the acture data in
> database is "020196010000".
 

> When FORM was executed, the master FILED1 has data with "02-01-1996" and
> no data was retrieved for detail block.
 

> After checking the SYSTEM.LAST_QUERY, I saw the query has bees executed
> looks like this:
> "Select FILED2 from detail where to_date(FILED2, 'MM-DD-YYYY') =
> to_date(MASTER.FIELD1, 'MM-DD-YYYY')"
 

> The query which the FORM executed does not include the hours, minutes and
> seconds. When it converts MM-DD-YYYYY to database format, the hours become
> 12 and 00 for minutes and senonds. Therefore, the FORM converts
> '02-01-1996' to "020196120000" and it won't match the detail block's data.
 

> I tried to modify the DEFAULT_WHERE clause in detail block and it does not
> work. Any ideas???????
> Please e-mail me if you have any idea... Thank you..
> my e-mail address is "kauj_at_lfs.loral.com"
Received on Fri Jun 21 1996 - 00:00:00 CEST

Original text of this message