|
These are records for maintaining a court docket. We make a additional record under the same "fileno" for each defendant in a particular suit. The court division number, county where filed, court case #, party suing and court date are the same for all defendants in a particular case.
We are trying to produce one report "court memo" for each case which contains the contains the above information for a particular "fileno" even though there may be several records with that same "fileno"; they are the same law suit at court.
We need to produce a report "court memo" which prints the names of all the separate defendants on the report, calling up the fileno by the non-unique "fileno".
The partial solution for the moment was the earlier suggestion of adding "AND LIMIT = 1" to the print statement which now just print the report once using the name of the defendant in the first record found in the search.
Thanks in advance for any suggestion you might have.
JIM VAN DILLEN
Attorney at Law
1505 S. Big Bend Blvd.
St. Louis, MO. 63117
(314) 645-8008; Fax (314) 645-8016
-------Original Message-------
Date: Tuesday, February 04, 2003 14:01:39
Subject: [RBASE-L] - Re: Extracting column values
I'm probably not getting it. My understanding is that up to 3 records
may have the same fileno, and you want the name info from one
record. It's not the fileno that I was wondering about, but the name
info.... do all the records have the same name information?
Ben Petersen
On 4 Feb 2003, at 13:45, Jim Van Dillen wrote:
>
> I know I have the right records since the "fileno" prints out on the
> report itself.
>
> -------Original Message-------
>
> From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Date: Tuesday, February 04, 2003 08:47:40
> To: RBASE-L Mailing List <mailto:[EMAIL PROTECTED]>
> Subject: [RBASE-L] - Re: Extracting column values
>
> Jim,
>
> You can append "and limit = 1" to the end of the where clause of your
> select/print statement.
>
> But, out of curiosity, how do you know you got the right one?
>
> Ben Petersen
>
>
> On 4 Feb 2003, at 1:16, Jim Van Dillen wrote:
>
> >
> > I am trying to create a report which extracts column values from
> > non-unique records.
> >
> > I need to extract name values for listing names in a report
> > searching for records by a fileno field which is non-unique (usually
> > never more than 3 records which could have the same fileno).
> >
> > Using a print statement as follows:
> >
> > Print <report> fileno = <colvalue>. The problem is that now if there
> > are two records under the same fileno, the report prints twice, once
> > for each name in a record under the same fileno instead one report
> > listing each name found.
> >
> > We have tried statements like:
> >
> > "Select into <var>, <tablename.colname> where fileno = <varfileno>"
> > but have still been having two (or more) reports print.
> >
> > Any help would be appreciated. You may reply privately if you wish.
> >
> > Thanks,
> >
> > JAMES L. VAN DILLEN
> > Attorney at Law
> > 1505 S. Big Bend Blvd.
> > St. Louis, MO. 63117
> > (314) 645-8008; Fax (314) 645-8016
> > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <
> mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >
> > > > > > >
>
>
> .
>
>
>
. | 
