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