|
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]>
> >
> > > > > > >
>
>
> .
>
>
>
. | 
