Operation must use an updatable query

  • Thread starter Thread starter EyeSpec
  • Start date Start date
E

EyeSpec

Query will not run I get the error: "Operation must use
an updatable query"

UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans
ON PHSCO_Elig.[Refract] = dbo_Tbl_Co_Refraction_Plans.
[Vision#] SET PHSCO_Elig.Block = [Block_Option_Code];


dbo_Tbl_CO_Refraction_Plans is an sequel table and is not
updatable. But PHSCO_Elig is a local table

Thanks
 
Query will not run I get the error: "Operation must use
an updatable query"

UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans
ON PHSCO_Elig.[Refract] = dbo_Tbl_Co_Refraction_Plans.
[Vision#] SET PHSCO_Elig.Block = [Block_Option_Code];


dbo_Tbl_CO_Refraction_Plans is an sequel table and is not
updatable. But PHSCO_Elig is a local table

Thanks
Click to expand...

Try using a Subquery then:

UPDATE PHSCO_Elig
SET PHSCO_Elig.Block =
(SELECT Block_Option_Code FROM dbo_Tbl_Co_Refraction_Plans
WHERE dbo_Tbl_Co_Refraction_Plans.[Vision#] = PHSCO_Elig.Refract);
 
I tried that also but it still would not update. I gave
me the same error. Any other suggestion???

Thx
-----Original Message-----
Query will not run I get the error: "Operation must use
an updatable query"

UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans
ON PHSCO_Elig.[Refract] = dbo_Tbl_Co_Refraction_Plans.
[Vision#] SET PHSCO_Elig.Block = [Block_Option_Code];


dbo_Tbl_CO_Refraction_Plans is an sequel table and is not
updatable. But PHSCO_Elig is a local table

Thanks
Click to expand...

Try using a Subquery then:

UPDATE PHSCO_Elig
SET PHSCO_Elig.Block =
(SELECT Block_Option_Code FROM dbo_Tbl_Co_Refraction_Plans
WHERE dbo_Tbl_Co_Refraction_Plans.[Vision#] = PHSCO_Elig.Refract);



.
Click to expand...
 
me the same error. Any other suggestion???

Check that PHSCO_Elig is updatable.

Use DLOOKUP instead of the select query:

dlookup("Block_Option_Code","dbo_Tbl_Co_Refraction_Plans",
"dbo_Tbl_Co_Refraction_Plans.[Vision#] = " & PHSCO_Elig.Refract)

(david)

EyeSpec said:
I tried that also but it still would not update. I gave
me the same error. Any other suggestion???

Thx
-----Original Message-----
Query will not run I get the error: "Operation must use
an updatable query"

UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans
ON PHSCO_Elig.[Refract] = dbo_Tbl_Co_Refraction_Plans.
[Vision#] SET PHSCO_Elig.Block = [Block_Option_Code];


dbo_Tbl_CO_Refraction_Plans is an sequel table and is not
updatable. But PHSCO_Elig is a local table

Thanks
Click to expand...

Try using a Subquery then:

UPDATE PHSCO_Elig
SET PHSCO_Elig.Block =
(SELECT Block_Option_Code FROM dbo_Tbl_Co_Refraction_Plans
WHERE dbo_Tbl_Co_Refraction_Plans.[Vision#] = PHSCO_Elig.Refract);



.
Click to expand...
Click to expand...
 
Back
Top