John, I tried what you suggested, re-ran the program. Same problem. It completely ignores the update lookup commands. Again, when I try at the R prompt, I don't receive the syntax error anymore but I still don't get the data. When I check the actual records, the data does exist in BIOFILE, and while a record with the same IDNO exists in FECUPLOADTEMP, the value of the FRCODE field does not get updated. Any other ideas? Paula -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Minyo II Sent: Wednesday, July 15, 2009 11:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Help! Program that worked is now broken.
Paula, Delete the index(keys), pack the database, recreate the index(keys), then pack the database again. John At 11:30 AM 7/15/2009, you wrote: That code generates a syntax error. I did check to see that the data is present by looking at sample records in both tables. Paula -----Original Message----- From: [email protected] [ mailto:[email protected] <mailto:[email protected]> ] On Behalf Of Dan Goldberg Sent: Wednesday, July 15, 2009 11: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]> 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] <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]> 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
