|
I know I have the right records since the "fileno" prints out on the report itself.
-------Original Message-------
Date: Tuesday, February 04, 2003 08:47:40
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]>
>
>
>
>
>
>
>
. | 
