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