replace hyperlink not working...

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

in table: FixtureCatalogsPages
I want to replace all of the entries in the field: CatalogSheetLink (data
type defined as "hyperlink")
where the current entry is: F:\TDA Master
Specifications\FIXTURECUTSHEETS\Lucifer\Housing\DHT_ZO.jpg
with a new hyperlnk

I have written this SQL staatement; however, when i run it, 0 rows are
updated.
I know they exist, because I copy/paste'd the "where" entry frrom the table
....any suggestions?

Update FixtureCatalogsPages
Set CatalogSheetLink = "new hyperlink - TEST"
where CatalogSheetLink = "F:\TDA Master Specifications\FIXTURE
CUTSHEETS\Lucifer\Housing\DHT_ZO.jpg"

thanks in advance,
mark
 
you cannot use a / in a where statement you need to use

Like "*F:?TDA Master Specifications?FIXTURE CUTSHEETS?Lucifer?Housing?
DHT_ZO.jpg*"

ebcause hyperlinks also have leaving characters and proceding
characters you cannot see

so try the sql

Update FixtureCatalogsPages
Set CatalogSheetLink = "new hyperlink - TEST"
where CatalogSheetLink Like "*F:?TDA Master Specifications?FIXTURE
CUTSHEETS?Lucifer?Housing?DHT_ZO.jpg*"

hope this helps

Regards
Kelvan
 
Back
Top