Re: Generator problem

From: Rick Banister <rick_at_sesame.com>
Date: 1995/09/18
Message-ID: <NEWTNews.811470553.12451.sesame_at_sesame.scruznet.com>#1/1

In Article<439ch1$ne4_at_coco.cri.dk>, <fpm_at_mentor.cri.dk> write:
> Path: news.scruz.net!garlic.com!fox.almaden.ibm.com!uunet!in2.uu.net!tank.news.pipex.net!pipex!dish.news.pipex.net!pipex!sunic!sunic.sunet.se!news.uni-c.dk!cri.dk!fpm
> From: fpm_at_mentor.cri.dk (Flemming P. Madsen)
> Newsgroups: comp.databases.oracle
> Subject: Generator problem
> Date: 14 Sep 1995 14:00:01 GMT
> Organization: Mentor
> Lines: 14
> Message-ID: <439ch1$ne4_at_coco.cri.dk>
> NNTP-Posting-Host: fpm.cri.dk
> Keywords: Relations, generator
> X-Newsreader: News Xpress Version 1.0 Beta #4
>
> Hi
>
> A Designer/2000 - Forms 4.5 generator problem:
>
> I have a simple master/detail construct. The problem is that I want to be
 able
> to control the maximum number of detail records for every master record.
>
> How do I tell the generator that the maximum number of detail records is say
 

> 2?
>
> Please help
>
> Flemming Madsen
> Mentor/Denmark

---

Assuming you really don't care what records are ignored by this operation, add the following clause to the WHERE clause in the BLOCK definition:

   WHERE ROWNUM < 3 Received on Mon Sep 18 1995 - 00:00:00 CEST