It looks like you are using a temp table. After you load the date in the temp table do you create an index on FECUPLOADTEMP.IDNO ? I have found that this solves a lot of mysteries with temp tables.
Also, try this syntax: UPDATE FECUPLOADTEMP SET FRCODE = T1.FRCODE FROM BIOFILE T1, FECUPLOADTEMP T2 WHERE T1..IDNO = T1.IDNO Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, July 15, 2009 10:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Help! Program that worked is now broken. Have you tried to see if there is data. select frcode from BIOFILE, FECUPLOADTEMP WHERE FECUPLOADTEMP.IDNO = BIOFILE.IDNO Dan Goldberg ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Paula Stuart Sent: Wednesday, July 15, 2009 7:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Help! Program that worked is now broken. Yesterday, right before I ran the program. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, July 15, 2009 10:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Help! Program that worked is now broken. Just curious, when is the last time you reloaded the database?? Dan Goldberg ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Paula Stuart Sent: Wednesday, July 15, 2009 7:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Help! Program that worked is now broken. I'm really under the gun here. I have a program that's been running properly for years (RBase 7.1). It is used to extract data from my client's database for quarterly reporting to the government. This involves extracting data from a number of tables and reformatting it in the manner required to import it properly. There are a number of lines of code that are do updates of data from various tables, based on matching IDNO (the primary key for the database). This has always worked before, and now when it runs, none of the data gets updated for those fields. I've checked that the IDNO'S match, the records exist. The data is there. The commands just aren't working. Can someone look at this code and tell me if there's a glitch I'm not seeing? I even tried loading this Database into 7.6 (client isn't up and running on new version yet but will be soon) Same problem. The I extracted one of the command lines (see below) and tried to run it at the R prompt. I got an error message (Syntax problem) and a "no rows exist or satisfy the specified clause" I've checked the tables. There are matching rows with appropriate data. UPDATE FECUPLOADTEMP SET FRCODE = FRCODE FROM BIOFILE, FECUPLOADTEMP WHERE FECUPLOADTEMP.IDNO = BIOFILE.IDNO
