[RBASE-L] - Re: Extracting values for a report

[Alastair Burr]

Jim,   If I'm reading your code correctly it looks as if you've simply got the syntax muddled for the select command. Try this:   set var vCourtCnty text = null   SELECT CTCNTY INTO vCourtCnty from TableName WHERE columnname = .whval1   set var COUNTY  text = null IF vCourtCnty CONT "CITY" THEN SET VAR COUNTY = "CITY" ELSE SET VAR COUNTY =  "COUNTY" ENDIF   Regards, Alastair.   ----- Original Message ----- From: Jim Van Dillen To: RBASE-L Mailing List Sent: Sunday, February 09, 2003 3:45 AM Subject: [RBASE-L] - Extracting values for a report I managed to get my report going using a LISTOF command and printing the report only once by using LIMIT = 1.   I am now trying to come up with reports specific to print for a particular court and county to be selected based on a search of a column  which contains the word "city" or "county".  In other words, a different layout of report based on what county you are in.   Presently we are trying a select command like:  FILLIN WHVAL1 "Using ....:" at 1 1   SELECT t1.CTCNTY INTO varname WHERE columnname = .whval1 IF CTCNTY CONT "CITY" THEN SET VAR COUNTY  TO "CITY" ELSE SET VAR COUNTY TO  "COUNTY" ENDIF   PRINT DOCKET_MEMO WHERE FILENO = .WHVAL1 AND LIMIT = 1   The report would then use the value of CTCNTY to fill in the proper "County" in on the proper report.   We have been unable to get beyond the SELECT statement.   The report works just fine if we just FILLIN a value for COUNTY before going into the report.   Any help?     JIM VAN DILLEN Attorney at Law 1505 S. Big Bend Blvd. St. Louis, MO. 63117 (314) 645-8008; Fax (314) 645-8016 [EMAIL PROTECTED]