Click here to Skip to main content
15,502,332 members
Home / Discussions / Database
   

Database

 
GeneralRe: Get date not exist Pin
Richard Deeming12-May-15 2:39
mveRichard Deeming12-May-15 2:39 
GeneralRe: Get date not exist Pin
Mycroft Holmes12-May-15 15:11
professionalMycroft Holmes12-May-15 15:11 
QuestionDatabase Pin
Member 116493918-May-15 20:14
Member 116493918-May-15 20:14 
QuestionRe: Database Pin
Richard MacCutchan8-May-15 22:40
mveRichard MacCutchan8-May-15 22:40 
AnswerRe: Database Pin
Richard Andrew x649-May-15 7:16
professionalRichard Andrew x649-May-15 7:16 
Questionupdate query not updating Pin
turnerdavid7-May-15 4:55
turnerdavid7-May-15 4:55 
AnswerRe: update query not updating Pin
ZurdoDev7-May-15 5:12
professionalZurdoDev7-May-15 5:12 
GeneralRe: update query not updating Pin
turnerdavid7-May-15 9:08
turnerdavid7-May-15 9:08 
SQL
SELECT JobTicket_024.file_link, JobTicket_024.Project_Number
FROM JobTicket_024
WHERE (((JobTicket_024.file_link)=Replace([JobTicket_024]![file_link],"'\\52qjkl-as-004v\CE_Data\CE\CEC\oce_drawings'","'F:\CE\CE\CE Drawings'")));


OK, first I changed UPDATE TO SELECT per your suggestion and I changed it to look at the "file_link" column and replace the "file_link"

Interestingly, the query shows a table and then an error message pops up with "Data type mismatch in criteria expression" and as soon as I click "help" it clears the table. And, the field isn't updated either.
GeneralRe: update query not updating Pin
ZurdoDev7-May-15 9:12
professionalZurdoDev7-May-15 9:12 
GeneralRe: update query not updating Pin
turnerdavid7-May-15 9:18
turnerdavid7-May-15 9:18 
GeneralRe: update query not updating Pin
ZurdoDev7-May-15 9:58
professionalZurdoDev7-May-15 9:58 
GeneralRe: update query not updating Pin
turnerdavid7-May-15 11:26
turnerdavid7-May-15 11:26 
GeneralRe: update query not updating Pin
ZurdoDev7-May-15 11:35
professionalZurdoDev7-May-15 11:35 
QuestionSybase Access Violaion Error Pin
Ankit RS6-May-15 22:32
Ankit RS6-May-15 22:32 
SuggestionRe: Sybase Access Violaion Error Pin
ZurdoDev7-May-15 5:08
professionalZurdoDev7-May-15 5:08 
GeneralRe: Sybase Access Violaion Error Pin
Sascha Lefèvre7-May-15 7:25
professionalSascha Lefèvre7-May-15 7:25 
QuestionRe: Sybase Access Violaion Error Pin
Ankit RS8-May-15 1:36
Ankit RS8-May-15 1:36 
AnswerRe: Sybase Access Violaion Error Pin
Sascha Lefèvre8-May-15 11:02
professionalSascha Lefèvre8-May-15 11:02 
QuestionUnion on a join Pin
jkirkerx6-May-15 10:20
professionaljkirkerx6-May-15 10:20 
AnswerRe: Union on a join Pin
Richard Deeming6-May-15 10:40
mveRichard Deeming6-May-15 10:40 
GeneralRe: Union on a join Pin
jkirkerx6-May-15 12:40
professionaljkirkerx6-May-15 12:40 
GeneralRe: Union on a join Pin
jkirkerx7-May-15 13:24
professionaljkirkerx7-May-15 13:24 
Questionpostgresql VACUUM Pin
V.6-May-15 0:55
professionalV.6-May-15 0:55 
JokeRe: postgresql VACUUM Pin
Tim Carmichael6-May-15 5:52
Tim Carmichael6-May-15 5:52 
GeneralRe: postgresql VACUUM Pin
Mycroft Holmes6-May-15 15:06
professionalMycroft Holmes6-May-15 15:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.