What is wrong with this Query?

[rebelscum0000]

Dear All

Can someone please let me know what is wrong with this query? When I
paste from the SQL View to my code (Module) all is in red

Thanks in advance

Regards,
Antonio Macias

sQL9 = _
"UPDATE Directories_C_Tbl SET Directories_C_Tbl.MyDirectories
= "DIR", Directories_C_Tbl.MyDirectoryPath = "C:\Dups V.1.0" " & _
"WHERE (((Directories_C_Tbl.MyDirectories) Is Null) AND
((Directories_C_Tbl.MyDirectoryPath)="C:\Dups V.1.0\"));


CurrentDb.Execute sQL9, dbFailOnError

 

[Dirk Goldgar]

In

Dear All

Can someone please let me know what is wrong with this query? When I
paste from the SQL View to my code (Module) all is in red

Thanks in advance

Regards,
Antonio Macias

sQL9 = _
"UPDATE Directories_C_Tbl SET Directories_C_Tbl.MyDirectories
= "DIR", Directories_C_Tbl.MyDirectoryPath = "C:\Dups V.1.0" " & _
"WHERE (((Directories_C_Tbl.MyDirectories) Is Null) AND
((Directories_C_Tbl.MyDirectoryPath)="C:\Dups V.1.0\"));


CurrentDb.Execute sQL9, dbFailOnError

You've got quotes in your quote-delimited SQL string (and also you don't
have a closing quote for the SQL literal. You need to either double up
the embedded quotes, or use single-quotes instead of double-quotes
within the string:

sQL9 = _
"UPDATE Directories_C_Tbl SET " & _
"MyDirectories = 'DIR', " & _
"MyDirectoryPath = 'C:\Dups V.1.0' " & _
"WHERE ((MyDirectories Is Null) " & _
"AND (MyDirectoryPath='C:\Dups V.1.0\'));"

 

[rebelscum0000]

In











You've got quotes in your quote-delimited SQL string (and also you don't
have a closing quote for the SQL literal. You need to either double up
the embedded quotes, or use single-quotes instead of double-quotes
within the string:

sQL9 = _
"UPDATE Directories_C_Tbl SET " & _
"MyDirectories = 'DIR', " & _
"MyDirectoryPath = 'C:\Dups V.1.0' " & _
"WHERE ((MyDirectories Is Null) " & _
"AND (MyDirectoryPath='C:\Dups V.1.0\'));"

--
Dirk Goldgar, MS Access MVPwww.datagnostics.com

(please reply to the newsgroup)- Hide quoted text -

- Show quoted text -

Thank you

I changed Is Null For ="" and it works

sQL9 = _
"UPDATE Directories_C_Tbl SET " & _
"MyDirectories = 'DIR', " & _
"MyDirectoryPath = 'C:\Dups V.1.0' " & _
"WHERE ((MyDirectories =''" & "" & "' ) " & _
"AND (MyDirectoryPath='C:\Dups V.1.0\'));"



CurrentDb.Execute sQL9, dbFailOnError "

Regards
Antonio Macias