Ned,
IF SQL = 100 THEN. Or you could try: WHENEVER NOT FOUND with a DECLARE CURSOR loop. Claudine _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ned Ritchie Sent: Friday, July 25, 2008 2:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - My mind is missing on a few cylinders this evening! I sat in a dentist chair for 5 hours and I'm not all here, and I cannot figure out the following: I've imported a Zip+4.cvs sales tax file supplied by our Washington State Dept of Revenue that has some missing Plus4 data due to new sub-developments and new construction and PO Boxes I can SET vLocalCode as a VARIABLE where there is a valid row, but when the valid USPS Plus4 is not in a Dept of Rev Plus4 range we of course get a "NO ROWS FOUND" I now need to find the row where the zipcode is the same and the starting Plus4 range is '0000'. I need to reset the vThisPlus4 variable to '0000' and then make a second go at finding the valid default row EXAMPLE: Any Plus4 up to 9734 will create a "NO ROWS FOUND" Sample data as supplied: ZIP PLUS4_LOW PLUS4_HIGH CODE STATE LOCAL TOT_RATE EFF_START EFF_END ----- --------- ---------- ---- ----- ----- -------- ---------- ---------- 98537 0000 0000 1400 0.065 0.018 0.083 07/01/08 09/30/08 98537 9735 9745 2500 0.065 0.013 0.078 07/01/08 09/30/08 98537 9747 9747 1400 0.065 0.018 0.083 07/01/08 09/30/08 98537 9801 9801 1402 0.065 0.018 0.083 07/01/08 09/30/08 *(Lots of Rbase for DOS code above) LABEL BadPlus4 CLEAR V vLocalCode SET V vLocalCode TEXT = NULL SET V vLocalCode = LocalCode IN Quarter_NOW WHERE ZipCode = .vThisZcode AND + .vThisPlus4 BETWEEN Start4 AND End4 *(Here is where I need to check if NO row was found) IF <something> THEN SET V vThisPlus4 = '0000' GOTO BadPlus4 ENDIF SET V vTotalTax = TotalTax IN Quarter_NOW WHERE ZipCode = .vThisZcode AND + .vThisPlus4 BETWEEN Start4 AND End4 My hope is that I awake refreshed and you folks who are in earlier time zones and with all cylinders firing will have supplied the missing line(s) of code or have told me where to look for the examples. Thanks in advance. Ned
