M
mcl
I have two tables (call them 1 & 2). They are linked by an ID number common
to both tables. I use table 2 just to supply an element for computations in
my query. I've been using this query to find unreasonable extreme values and
delete them for some time from table 1. Suddenly it stopped working where it
would not let me delete the extreme values. I checked the properties for
that "unique records" thing. That wasn't the problem. Then I realized I had
just downloaded a revised version of table 2 in oracle from our servers. So
I looked there. The only thing I changed was the downloaded table had no
primary key. I made the ID number in table 2 the primary key. With that
change I could strart deleting again in the query. In fact it makes no dif
whether I have that "Unique Records" set to yes or not. It just works. Any
explanation.?
to both tables. I use table 2 just to supply an element for computations in
my query. I've been using this query to find unreasonable extreme values and
delete them for some time from table 1. Suddenly it stopped working where it
would not let me delete the extreme values. I checked the properties for
that "unique records" thing. That wasn't the problem. Then I realized I had
just downloaded a revised version of table 2 in oracle from our servers. So
I looked there. The only thing I changed was the downloaded table had no
primary key. I made the ID number in table 2 the primary key. With that
change I could strart deleting again in the query. In fact it makes no dif
whether I have that "Unique Records" set to yes or not. It just works. Any
explanation.?