strange query behavior

  • Thread starter Thread starter steph
  • Start date Start date
S

steph

Hi everyone,

I've got a query that looks like this:

SELECT SAM_ID, EXP_TYPE, NMR_STATUS, NMR_CONCENTRATION, CREUSER,
CREDATE, MODUSER,
FROM QUAL_CONTROLs
WHERE exp_type="NMR";

Nevertheless when I open the query in datasheet view, the query returns
other values in column exp_type besides only "NMR". I'm puzzled. How
can this happen??

regards,
stephan

ps: I'm using access 2002
 
Hi everyone,

I've got a query that looks like this:

SELECT SAM_ID, EXP_TYPE, NMR_STATUS, NMR_CONCENTRATION, CREUSER,
CREDATE, MODUSER,
FROM QUAL_CONTROLs
WHERE exp_type="NMR";

Nevertheless when I open the query in datasheet view, the query returns
other values in column exp_type besides only "NMR". I'm puzzled. How
can this happen??
Click to expand...

Well, it certainly shouldn't!

Do you see all the records in your table, or only some?

It's possible that an Index on your table has become corrupt. Back up
the database RIGHT NOW (and don't overwrite any existing backups, you
may need them). Try Compacting the database (Tools... Utilities...
Compact and Repair); if exp_type is indexed in table design, try
deleting the index; compacting the database; recreating the index, and
compacting a second time.

John W. Vinson[MVP]
 
oops, i found out now: the query goes on a linked table, which is a
view in oracle. unfortuantely i've chosen a primary key fiels which is
not unique :-(
 
oops, i found out now: the query goes on a linked table, which is a
view in oracle. unfortuantely i've chosen a primary key fiels which is
not unique :-(
Click to expand...

Then it's not a primary key... <g>

Yep. That will cause exactly this problem.

John W. Vinson[MVP]
 
Back
Top